G
Guest
I have 3 tables. Two of the tables link to the third table with a one to many
relationship... the one table having one record per 'instance' and the two
linked tables having multiple records per instance (but not necessarily the
same number of multiple records per single record in the 'main' table).
My problem is this: Each of the two linked tables could have anywhere from 0
to 3 records per record in the main table. I would like to have a form where
the fields for the main table is available along with 3 sets of fields for
one linked table and 3 sets of fields for the other linked table. All on one
form page. Once the user enters the data, I'd hope that all the data could go
to the right tables, correctly linked.
Am I a hopeless dreamer or can this be accomplished? If so, could someone
please point me in the right direction?
Thanks!
Emma
relationship... the one table having one record per 'instance' and the two
linked tables having multiple records per instance (but not necessarily the
same number of multiple records per single record in the 'main' table).
My problem is this: Each of the two linked tables could have anywhere from 0
to 3 records per record in the main table. I would like to have a form where
the fields for the main table is available along with 3 sets of fields for
one linked table and 3 sets of fields for the other linked table. All on one
form page. Once the user enters the data, I'd hope that all the data could go
to the right tables, correctly linked.
Am I a hopeless dreamer or can this be accomplished? If so, could someone
please point me in the right direction?
Thanks!
Emma