appreciate your help for a solution of the following problem.
Table 1 has only one text field called "Item". The entries are unique, e.g. A, B, C, D.
Table 2 has a text field called "MyItem", and I use the entries of Table 1 as a value list to make a selection for an entry in Table 2.
Now, it might happen that an entry in table 1 is missing, say 'E'. I would like to enter an 'E' in table 2 and ensure that this new entry is also copied into table 1 as a new entry. I made several attempts with relationships and references. Both do not work.
Thanks for your help,