Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Best way to allow multiple one-to-many relationships

I have one main table and about 30 sub-tables with one-to-many relationships.  Each record in the sub-tables can also have multiple photos. 

What is the best way to handle this?  I would rather not have another photos table for every sub-table, but I don't see another solution for this.

Thanks for any tips or pointers.

0 5 226
5 REPLIES 5
Top Labels in this Space