Database Design Questions/Help!

[jbs]

Hi All,

I'm currently working on a database that has 12 tables of infomation, with an ID Code as the primary key in each table.

The ID Code represents a person and is the same for each unique person across the 12 tables. I envision to link all the like items together so when i type in an ID Code on a form, it will bring up all the infomation across the 12 tabes relating to this ID Code.

Im after some tips and pointers on how this can be done, if anyone has any idea it would be greatly appreciated!

Please let me know if my explanation is not adequate and I will try to explain further.

Thanks!

 

[bob fitz]

Can you tell us a little more about these 12 tables and the kind of data that they contain.
I asume that one table has the ID as a primary key and the other 11 tables have it as a foriegn key. Is that correct?
I asume that there is a one to many relationship between the table that has the primary key ID and the other 11 tables. Is that correct?

 

[jbs]

Hi Bob,

Thanks for the reply. I have linked the primary keys of the 12 tables to the 1 source table i have and then created a query off the relationships to display the fields that i want and it seems to work well.

My next step is to create a form that will display all the infomation from the query when a name/ID is selected.

 

[bob fitz]

can you show us a screen shot of the relationships and/or tell us a little more about these 12 tables and the kind of data that they contain.