hey derek, thx for your reply! regarding your questions pls see following requirements in red.
1. when creating or maintaining a 'main' record, once you select entries from the 'catalogue' table into your 'main' record, do you then ever make any manual adjustments to 'main_add.memo1' and 'main_add.memo2' or is it always exactly as copied from the 'catalogue' table (the reason for asking is that you don't have a relationship between the 'catalogue' and 'main' tables). --> yes, entering main records, i want to make manual adjustements to every field, also to the two ones from the catalogue. therefore, i am not using relations and comboboxes.
2. does 'catalogue.field1' always get copied into 'main.cataolgue1' and 'catalogue.field2'. into 'main.catalogue2' or can 'catalogue.field1'. ever go into 'main.catalogue2' and vice versa? --> no, they strictly go the the first mentioned fields, no exchange here
3. do 'main.catalogue1' and 'main.catalogue2' always get taken from the same row in the 'catalogue' table? Or, for example, could you select the 'catalogue.field1' value from row 7 in the 'catalogue' table and the 'catalogue.field2' value from row 12 in the 'catalogue' table. In other words, can you 'mix and match' or do 'catalogue.field1' values and 'catalogue.field2' values always come as pairs? --> no mix and match here, catalogue.field1 and 2 are always from the same row
many thanks in advance for your kind help! :-)