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?