I have a simple SQL 2000 database with an Access 2000 front end. There are 3 tables, CLIENT, CONSULTANT and WORK. The WORK table references Client_Name and Consultant_Name from the primary keys of the other tables. There is a WORK_INPUT FORM which displays all the WORK TABLE fields with Combo boxes for Client_Name and Consultant_Name. This all works fine for standard inputting of WORK data.
What I want to do is to give the user (using the Access 2000 front end) an option to select a Client_Name from a drop-down list and show (via the WORK_INPUT FORM) only those records in the WORK TABLE which contain that Client_Name - allowing the user to View/Add/Amend/Delete records for that Client_Name.
Can you suggest the easiest way to do this ?
Thanks, Clive.
What I want to do is to give the user (using the Access 2000 front end) an option to select a Client_Name from a drop-down list and show (via the WORK_INPUT FORM) only those records in the WORK TABLE which contain that Client_Name - allowing the user to View/Add/Amend/Delete records for that Client_Name.
Can you suggest the easiest way to do this ?
Thanks, Clive.