3 Tables
Client
Skills
AssistanceRequested
1. Client table has a field called Client_ID that is auto-numbered automatically by Access and becomes the unique primary key for the client. This table stores personal info (name, address, phone, etc.)
2. Two additional tables are related to Client. They are Skills and AssitanceRequested and they are linked through the field Client_ID. I created a subform on the Client form that accesses the Skills table when a record is selected in the Client form. It displays the many skills associated with this client.
3. When a new client is entered into the Client table, I would like the data entry person to have the option of: 1. Saving the Record and moving on. 2. OPening up a subform to add data to the "Skills" table and/or Open up the AssitanceRequested TAble to add records.
To keep the screen neat and tidy, I don't want both the Skills and AssitanceRequested tables to be open at the same time.
What's the best way to accomplish this?
THanks everyone!
Client
Skills
AssistanceRequested
1. Client table has a field called Client_ID that is auto-numbered automatically by Access and becomes the unique primary key for the client. This table stores personal info (name, address, phone, etc.)
2. Two additional tables are related to Client. They are Skills and AssitanceRequested and they are linked through the field Client_ID. I created a subform on the Client form that accesses the Skills table when a record is selected in the Client form. It displays the many skills associated with this client.
3. When a new client is entered into the Client table, I would like the data entry person to have the option of: 1. Saving the Record and moving on. 2. OPening up a subform to add data to the "Skills" table and/or Open up the AssitanceRequested TAble to add records.
To keep the screen neat and tidy, I don't want both the Skills and AssitanceRequested tables to be open at the same time.
What's the best way to accomplish this?
THanks everyone!
Last edited: