Parsing from form to multiple records

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
This naturally how ms-access works.

For each "many" side, you simply place a sub-form on the screen. Ms-access
will do all the work for you, and no code is needed.

You can even display main records from the "main" table, and have "display"
of the records for the current main record selected. Here is some screen
shots of this idea here:

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm
 
Back
Top