AnsweredAssumed Answered

Dynamic List

Question asked by FlipFlop on May 8, 2011
Latest reply on May 8, 2011 by FlipFlop


Dynamic List


Hello Everybody,

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,