One-to-many Relationship Question

[Valheru]

Is it unheard of to have several tables that are all one-to-many to one main table? The main table is "Company" and all other tables are soley linked to it through CompanyID. E.g. Contacts, Devices, Connections, Users, Protocols, and Merchants can all have several of each connected to just one company. Am I doing this right?
Thank you for your time.

 

[LittleSmudge]

EXACTLY right

As long as Devices, Connections, Users, Protocols don't have links between themselves that would be more appropriate than linking directly to the Company table.

There is no reason why not. - It sounds like you are securely on the right track.


G LS