Relationships

M

MaRSMAN

Is it ok to have many about 15 tables linked to one table
example Soulstbl ID linked to addresstble soulsIDfgk and communiontbl
soulsIdfgk and baptimstbl soulsIDfgk and so on for the 6 or 7 others I have.
some table will be one to one while athers will be one to many. All comments
appreciated thanks Marsman
 
J

John W. Vinson

Is it ok to have many about 15 tables linked to one table
example Soulstbl ID linked to addresstble soulsIDfgk and communiontbl
soulsIdfgk and baptimstbl soulsIDfgk and so on for the 6 or 7 others I have.
some table will be one to one while athers will be one to many. All comments
appreciated thanks Marsman
Click to expand...

Yes. You can have dozens of related tables. However, one to one relationships
are only rarely necessary; you can just include fields in the soulstbl for
(say) date of first communion. NULL values take up no space in the database,
so you can just leave that field empty.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
How to have two tables on same line? 1
List all tables, including document structure 0
Converting URLs in comments to Markdown-formatted links 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Embed the same Excel multiple times 0
Treating multiple paragraphs as one 2
Unclear change tracking process 0

Top