Hi,
I have prepared a form for adding a record in a table1. This table has foreign compound key (4 fields) resulting form a relation with another, table2. I am trying to prepare a list box that select the compound key (4 fields) from table2 and assign them to the new record in table1. If the compound key is chosen, a 5th field in table2 has to be chosen and the control on the form has to be blocked.
How could I assign 4 fields from the list box to 4 fields in the form by selecting them at the same time?
I hope that I am clear.
Thank you.
I have prepared a form for adding a record in a table1. This table has foreign compound key (4 fields) resulting form a relation with another, table2. I am trying to prepare a list box that select the compound key (4 fields) from table2 and assign them to the new record in table1. If the compound key is chosen, a 5th field in table2 has to be chosen and the control on the form has to be blocked.
How could I assign 4 fields from the list box to 4 fields in the form by selecting them at the same time?
I hope that I am clear.
Thank you.
