1. Computing

Discuss in my forum

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!
Comments
No comments yet. Leave a Comment
Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>
  1. About.com
  2. Computing
  3. Databases

©2014 About.com. All rights reserved.