This might be a crazy question but can you ha...

references
(Tammi Canelli) #1

This might be a crazy question but can you have a table that is referenced to multiple tables?

I’m wondering if I could have one check in table that is related to 4 registry tables.

Perhaps if I added the key column from each registry table to checkin and reference them that way?

I figured I’d ask before I attempted this.

(Philip Garrett) #2

@Tammi_Canelli

If you are asking if a table can contain Refs to two or more tables, then the answer is yes. This is how you model many to many relationships.

For example, you could have a Students table, a Classes table, and an Enrollments table. The Enrollments table can have one Ref to Students and another Ref to Classes. Each record in the Enrollments table represents the enrollment of one student in one class.