auto lookup queries

[Guest]

I have followed the instructions (as far as I can tell) in Help, and have
looked carefully at how tables/queries are structured in the sample database.
I can get data to enter automatically in a query and form, but not in the
underlying table - as it does in the sample database.

I have:
Prices Table: PricesID, Code, Description
Structures Table: OrderID, PricesID, ItemCode, ItemName

I need ItemName (same as Description) to be populated when ItemCode is
entered.

Crazy Lady

 

[Guest]

You don't. If you already have data in one column, why put it in another? In
fact you seldom put derived data of any kind in a table. For example if you
have the Date of Birth, you should not also store the Age as you can always
figure it out from the Date of Birth.

In your case you can always pull the item name from the Description in the
Prices table by joining these two tables by the Prices ID field.

 

[Guest]

Hi Jerry,

I guess you're right, I shouldn't have the same field in two tables. I'll
just have the field autopopulated in a query and form.

I have joined the two tables by the prices ID field but the I can't get it
to auto populate in this way.

Thanks for you time and help

Crqzy Lady