G
Guest
I'd like to be able to perform data entry for fields from 4 tables, in a
single data entry interface. (I'm using Access 2002, SP3.)
Is there a way for this data entry to be done from a single interface in
Form view?
The only data entry "interface" solution of which I am aware is not very
good. This solution consists of creating a Form from one table, and then
adding 3 separate subforms (each subform bound to one of the 3 remaining
tables). With this solution, data entry for the fields in the 3 subforms
must be done via the 3 subform "datasheets."
I find this data entry "interface" solution to be really poor. Further, the
solution is made worse because horizontal scrolling is required for data
entry into each subform (as the number of fields in each subform does not fit
in the visible portion of datasheet).
Any help will be greatly appreciated.
single data entry interface. (I'm using Access 2002, SP3.)
Is there a way for this data entry to be done from a single interface in
Form view?
The only data entry "interface" solution of which I am aware is not very
good. This solution consists of creating a Form from one table, and then
adding 3 separate subforms (each subform bound to one of the 3 remaining
tables). With this solution, data entry for the fields in the 3 subforms
must be done via the 3 subform "datasheets."
I find this data entry "interface" solution to be really poor. Further, the
solution is made worse because horizontal scrolling is required for data
entry into each subform (as the number of fields in each subform does not fit
in the visible portion of datasheet).
Any help will be greatly appreciated.