A problem: I currently have a single contacts database for membership it contains about 2400 records. But now management would like to track a history of dues paid by membership. I made another table to record requested information. The problem is how to relate the new table to the old one. If used together no records show up.
Would doing the following solve my problem? Can I copy my single table MEMBERS and rename it to DUES. Taking the DUES table, can I delete all fields but the notes field Add desired new fields Add a new DuesID Make it the primary key Take the MemberID change the data type to NUMBER make it a foreign key Then relate the two tables in the RELATIONSHIPS module Will the tables work together?
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 Expert 1.
