A quick question for planning. Our database includes many married couples. Is it best to add the spouse information in another record as a subform to include the 2nd phone, cell phone, email address etc. or just have double fields in the main record. That is for example, FirstName1, FirstName2, Phone1, Phone2 etc.
Reply from Richard Rost:
This is completely up to you and your needs. You can store the spouse as a related, second record and just link them together somehow OR if you don't collect that many of them (or need to use the data that often) then just add additional fields. It's all based on YOUR database needs.
Personally, I prefer to use a SELF JOIN as I cover in my RELATIONSHIP SEMINAR. Each "person" in the database is in the PersonT table, and in a subform I specify all of the relationships. This way you can create separate records for everyone in the family (mom, dad, kids, grandparents, etc.) and everyone gets related to everyone else.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 1.
