Auto Complete Data

[Guest]

I think I basicly understand how the linking works. The room Id links to the
home inventory table . This allows you to use a combo box that can store the
room name with a limited amount of typing into the home inventory table.

How can I have a combo box that will autopopulate about 5 other combo boxes.
If I enter a record ID I get what I want. But I can't remember that many
ID's. I have about 3 different grades of a product. Basically High, Medium
and Low of a sofa, chair etc. Instead of Sofa/High-Medium-Low should I name
them in the same field of a table Sofa-High Sofa-Medium Sofa-Low. I know the
more you break out in a database, the more versatile it is. I guess I just
have to many variables.
Frank.

 

[John Vinson]

I think I basicly understand how the linking works. The room Id links to the
home inventory table . This allows you to use a combo box that can store the
room name with a limited amount of typing into the home inventory table.

How can I have a combo box that will autopopulate about 5 other combo boxes.
If I enter a record ID I get what I want. But I can't remember that many
ID's. I have about 3 different grades of a product. Basically High, Medium
and Low of a sofa, chair etc. Instead of Sofa/High-Medium-Low should I name
them in the same field of a table Sofa-High Sofa-Medium Sofa-Low. I know the
more you break out in a database, the more versatile it is. I guess I just
have to many variables.
Frank.

The solution is... you probably DON'T!

If you can identify the Grade based on the selection of the sofa in
the home inventory table, then you don't NEED to store that
information in the home inventory table at all. Store it in the table
with the sofas, and *look it up* when you need it. You can display it
on the Form by including the grade field in the combo box's RowSource
and putting a textbox on the form with a control source

=cboFurniture.Column(n)

where cboFurniture is the name of the combo box and (n) is the *zero
based* subscript of the field containing the grade.

John W. Vinson[MVP]

 

[Guest]

John or anyone please;

I think that I was on the wrong track. I think that I am on the right track
now. I bought book from M about access 2003.

What I am trying to do is establish relationships between the tables. I am
trying to use ProductID to establish a relationship between the Customer and
Product Table so that I can create an order form. They can only order once so
the only reason to have them seperate is to be able to update pricing
information on a global basis.

The wizard will build a relationship of one - many with the customer being
many. I think that what I need is for the customer to be one and the product
to be many. It will only allow to build it the other way around or with a one
to one relationship.

Am I even on the right track??

Thanks for your help. Frank.

 

[Guest]

Forget this Post. I got the relationships to work. Thanks