Hey all,
My question involves 3 different tables (each table controls a combo-lookup box which I want to be able to add fields to at anytime, the tables just have 1 key field and 1 detail text field). All three tables are not related to each other, nor do they need to be. I wanted to save space and amount of forms I am using, so I am trying to make 1 form which will allow the user to add records to each of these tables. Is this possible? or is there no easy way to force a form to control 3 unrelated tables.
I did some searching and I feel like sub forms may be the key but I am not too familiar with using those yet.
Thanks in advance!
PS I am using Access 2010, on windows 7
My question involves 3 different tables (each table controls a combo-lookup box which I want to be able to add fields to at anytime, the tables just have 1 key field and 1 detail text field). All three tables are not related to each other, nor do they need to be. I wanted to save space and amount of forms I am using, so I am trying to make 1 form which will allow the user to add records to each of these tables. Is this possible? or is there no easy way to force a form to control 3 unrelated tables.
I did some searching and I feel like sub forms may be the key but I am not too familiar with using those yet.
Thanks in advance!
PS I am using Access 2010, on windows 7