Multiple records viewed on multipage form

[jweber]

I am working on a computer inventory database. We want to record some of the individual components in the various machines (as we build all our computers in-house). I have made a table for components, a table for configurations, and a table for software. I would like to be able to use a form that shows ALL of the associated records for one machine on a multipage form, each page of the form devoted to one table and the associated records. Is this even possible? Please don't worry about suggesting code here. I'm sort of looking for the best way to do this. Thank you.

 

[jbehrne]

Hi,

You should be able to do this easily. You will have to link all of your tables via some sort of field (I.E. - Computer serial number) Each record in the other tables should reference this number (create a foreign key in the other tables). Then for your main form display the computer serial number table, each of the other tables will become subforms linked to the main table by the serial number field).

I actually have a database that already does this (you can modify it to fit your needs). If you are interested e-mail me @ jbehrne@hotmail.com

jbehrne