![filemaker pro 11 consistency check now not responding filemaker pro 11 consistency check now not responding](https://0.academia-photos.com/attachment_thumbnails/49303394/mini_magick20190131-6217-15s33qh.png)
#Filemaker pro 11 consistency check now not responding how to#
However, I am stuck at how to check if the $keyword is present in the Keywords table and then how to get the id of that $keyword from the Keywords table. This is the step-by-step script I am attempting to write. Set variable $keywordID with value of id field Get id of $keyword and put in variable $keywordIDĬheck if $keywordID is already tagged to eventĭisplay message, "this keyword has already been added to this event"Ĭreate new record in Tags table with $keywordID and $eventIDĬreate new record in Keywords table with $keyword value in keyword field
![filemaker pro 11 consistency check now not responding filemaker pro 11 consistency check now not responding](https://flylib.com/books/2/128/1/html/2/images/fmakerprotmm_1810.jpg)
Set variable $keyword with value from global fieldĬheck if $keyword is present in Keywords table
![filemaker pro 11 consistency check now not responding filemaker pro 11 consistency check now not responding](https://photos5.appleinsider.com/gallery/45680-88880-211116-FileMakerPro-xl.jpg)
Set variable $eventID wtih ID of current event Then a script would do the following: Enter keyword in global field In order to implement this, I thought I could have a global field where the user enters the keyword they want. If it doesn't exist, it should be created and then added as a tag. Now, in order to add keywords as tags to an event, I want to make sure the keyword has not already been added and that it exists in the tables of keywords. Therefore, I have created a three tables, structured as such: I want to be able to tag each event with keywords. I have a FileMaker 14 database of events.