compare data dynamically while entering

Discussion created by jgaglio on Apr 15, 2014
Latest reply on Apr 15, 2014 by jgaglio

Uning FileMaker Pro 11


Table A Orders- Sales department

Table B Materials - Master material list, administrator access only


In table A, I want to show a message telling user they are entering a new material if it isn't already in the value list and then allow them to enter a new entry. This entry needs to populate the master list, table B. The value list comes from the Material fieled in table B. Since FM doesn't allow editing of a value list if it uses a field value from in this case, table B, how do I compare the entry from the two tables and give the option of adding to the list in table B which is locked out from Sales department?