Hello,
I have a table "Speakers". For each speaker, there can be more than one
disclosure [say, in the table "Disclosures"]. Yet at the same time, only one
of those disclosures is current, the others are old data that needs to be
kept around for analytical purposes.
When I link speaker and disclosures in a one-to-many relationship, I can
assign several disclosures to one speaker, and when I link disclosures and
speakers in a one-to-many relationship, I can assign a specific disclosure to
a speaker.
But I need to do both at the same time, and I have not been able to.
What do I need to do differently?
Thank you.
I have a table "Speakers". For each speaker, there can be more than one
disclosure [say, in the table "Disclosures"]. Yet at the same time, only one
of those disclosures is current, the others are old data that needs to be
kept around for analytical purposes.
When I link speaker and disclosures in a one-to-many relationship, I can
assign several disclosures to one speaker, and when I link disclosures and
speakers in a one-to-many relationship, I can assign a specific disclosure to
a speaker.
But I need to do both at the same time, and I have not been able to.
What do I need to do differently?
Thank you.