Hi there, I'm very new to Access, and was wondering if someone coulde help me with the following problem:
I have two tables in a database with the following attributes -
Client, Client ID (Primary key), Client Name
Asset, Asset ID (Primary key), Client ID (foreign key), Asset description
Relationship = Many assets to one client.
What I want is to create a form that will let me enter asset details for different clients. The main problem is that I want the form to show assets currently registered to a specific client by typing in their ID, but the form I have at present only lets you change the ID. I.e. I need the form to update itself based on the client ID entered.
Can you help? If so, stop by our forum today!