I am creating a database (actually, restructuring a pre-existing one from Alpha 4) that holds contacts for fundraising purposes. Obviously, in the old database, information like the name, addresses, and contact numbers are stored. Right now there are two sets of fields for addresses and contact numbers for each record.
I was thinking that I should take the address fields (primary and secondary address) and make them into a child table with each address as a record (rather than a bunch of fields) so I can accommodate more than two addresses and make it more efficient in general. I am also planning to add a field in the address child table that would denote whether the address is primary, secondary, etc., and perhaps another field that would say the kind of address (e.g. home, work, etc.). The parent table would have, among other fields, their name and their firm/company.
A major function of the database is to print out labels and/or letters to the contacts in the database. I would want the letter or label to only print out the address record that is marked "Primary." But how would I get the firm name (since it is in the parent table) to be included in the address, if the primary address is the firm address? How would I get the firm name to not show up if the primary address is the home address? And how would I show the mailing address (whether it is the firm address or home address) to be properly displayed in a form. What's the best way to do all this?
Any help would be very much appreciated.
I was thinking that I should take the address fields (primary and secondary address) and make them into a child table with each address as a record (rather than a bunch of fields) so I can accommodate more than two addresses and make it more efficient in general. I am also planning to add a field in the address child table that would denote whether the address is primary, secondary, etc., and perhaps another field that would say the kind of address (e.g. home, work, etc.). The parent table would have, among other fields, their name and their firm/company.
A major function of the database is to print out labels and/or letters to the contacts in the database. I would want the letter or label to only print out the address record that is marked "Primary." But how would I get the firm name (since it is in the parent table) to be included in the address, if the primary address is the firm address? How would I get the firm name to not show up if the primary address is the home address? And how would I show the mailing address (whether it is the firm address or home address) to be properly displayed in a form. What's the best way to do all this?
Any help would be very much appreciated.
Comment