A related table is one possibility which would be fine if I had a large number of rows in my table 'papers'. For not-so-large tables, the multivalued fields should be fine. As Ranman256 points out, I need to monitor the order in which I check the individual names in the combo box. Ideally, I...
Hi all.
I am Roman Gröger and work as a research scientist at the Academy of Sciences of the Czech Republic. I have been using Access occasionally for about 15 years :rolleyes:.
Best,
Roman
Dear all.
I have the following problem concerning the multivalued fields in Access. My table 'names' contains names:
Peter
John
Scott
My 'papers' table contains a multivalued field 'authors' which stores multiple names selected using a combo box from the table above. If I first check...