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?