Home
Forums
New posts
Search forums
Articles
Latest reviews
Search resources
Members
Current visitors
Newsgroups
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
Newsgroups
Microsoft Access
Microsoft Access Database Table Design
Creating Extended Family Listing
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
[QUOTE="jbc, post: 4990912"] I'm creating a database of my family and extended relatives. I need to keep track of mailing address, phone number, birthdays. Reports need to create. Mailing labels, listing of family members by household, birthday listing. I created 2 tables. One with household information: tblMainAddress ID LastName StreetAddress City State Zip HomePhone EmailAddress Email2Address ID Primary key tblMembers ID MemberID FirstName Birthday Addressee1st Y/N Addressee2nd Y/N Child Y/N ID Primary key Both tables linked one to many ID (tblMainAddress) to MemberID data integrity enforced I have addressee1 and 2 for the labels I want to have control over which name appears first. The trouble I am having is getting a listing: Want it to appear like this: LastName, FirstName (addressee1)& FirstName (addressee2 StreetAddress City, State Zip Phone Children: xxx, xxx Having trouble getting this to happen without duplicating the home address for each person. Is there something wrong with my logic in setting up the database? Any suggestions would be appreciated. jbc [/QUOTE]
Verification
Post reply
Home
Forums
Newsgroups
Microsoft Access
Microsoft Access Database Table Design
Creating Extended Family Listing
Top