Relationships

  • Thread starter Thread starter MaRSMAN
  • Start date Start date
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
 
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.
 
Back
Top