In a recent forum posting, GLENNANDREWC asks:
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!
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!
Comments
No comments yet. Leave a Comment