My database is fairly simple and consists of 3 forms for the entire process:
1. Client information
User inputs - file # (primary key), last name, first name
2. File Sumarry - conatains all other fields, with the exception of the 3rd forms fields
3. Concessions and amounts
What I thought was the file # to be the primary key for each table and to be used as the joining property
What I am looking to do is have the user input the file # on the first form and have that number auto-poulate the other tables/forms correctly. But I have been unsuccessful. When I bring up the 2nd and 3rd forms, the fields are empty but the underlying tables have the data in them. Help?
1. Client information
User inputs - file # (primary key), last name, first name
2. File Sumarry - conatains all other fields, with the exception of the 3rd forms fields
3. Concessions and amounts
What I thought was the file # to be the primary key for each table and to be used as the joining property
What I am looking to do is have the user input the file # on the first form and have that number auto-poulate the other tables/forms correctly. But I have been unsuccessful. When I bring up the 2nd and 3rd forms, the fields are empty but the underlying tables have the data in them. Help?