G
Guest
I have a database that has 5 different tables (A,B,C,D,E). Each table has a
primary key field called id. We needed data entry to be done using one form.
So I created the main form using the fields found on table A. I created
subforms on this main form so I could add the fields from tables B-E (joined
on id). Ideally we would like the users to enter the id only once (on the
main form, table a, id field). Once they have done that, we would like that
value to be prepopulated onto the subsequent subforms (tables B-E, each id
field). We do NOT want the users to be able to choose an id number on these
subforms using a combo box, as this is what it is currently doing. We just
want the number to appear in each of the subsequent tables/subforms. I know
this can be done, but is there an easy way to do this? Any help would be
appreciated.
primary key field called id. We needed data entry to be done using one form.
So I created the main form using the fields found on table A. I created
subforms on this main form so I could add the fields from tables B-E (joined
on id). Ideally we would like the users to enter the id only once (on the
main form, table a, id field). Once they have done that, we would like that
value to be prepopulated onto the subsequent subforms (tables B-E, each id
field). We do NOT want the users to be able to choose an id number on these
subforms using a combo box, as this is what it is currently doing. We just
want the number to appear in each of the subsequent tables/subforms. I know
this can be done, but is there an easy way to do this? Any help would be
appreciated.