I want to make a mails register. I have 3 different tables with different kind of informations (family members, customers, shops). In every table I have address information.
I want to have a registry of my sended/received mails. I want to have a field for a send/receive date, ID, etc. I also need a field for address which I would like to take from the right table. I think about making a conditional value list:
1. Family members
and then to link every choice with the addresses from that table.
Is it a good way? Maybe there is another solution?