too many primary Keys????

[babs]

I did what was suggested below- and it worked and grabbed the RATE field in
the query from the rates table. However I needed to add the delivery yard
Name and the pickupd yard name to both tables because there could be the same
deliv yd number with a different name.

Adding the two new fields to the rates tables as additional primary keys and
to the tankentry table as foreign and joining them in the query - makes the
query now updatable.



Thanks for your help,
Barb
From before:

I have a table that has a delivery yard, pickup yard, and type of
material(2choices). Based on that combination of what is in those three
fields there is a given RATE. On the form based on this table I would like
the rate to automatically fill based on the combination of the 3 fields
chosen. Seems like it should be easy not sure where I go with this.

Thanks,
Barb

John Vinson 8/31/2006 12:54 PM PST

I have a table that has a delivery yard, pickup yard, and type of
material(2choices). Based on that combination of what is in those three
fields there is a given RATE. On the form based on this table I would like
the rate to automatically fill based on the combination of the 3 fields
chosen. Seems like it should be easy not sure where I go with this.

Thanks,
Barb

I'd suggest creating a Rates table with four fields - these three as a
joint Primary Key and the corresponding rate. You can then create a
Query joining your current table to this rate table by the three
fields (two yards and a type) to look up the rate.

John W. Vinson[MVP]

 

[KARL DEWEY]

How is it that a delivery yard number has more than one name? Are there
different rates when the name is different?

Post your SQL.