Help! Logic gone AWOL today!!

M

MeWivFree

Hi all

Can someone help me sort out my logic here?

I have 3 tables as follows

Prices MaintItems EquipList
PriceCode (unique) ItemName (unique) CustomerID
Price (unique) PriceCode ItemID
(unique)

Pricecode

ItemName

Prices holds a list of prices that we charge for items, which are identified
in other tables using the PriceCode (so I only have to update our charges in
one place in the future.)

MaintItems holds a list of all the possible items that we service, plus the
price code for that item.

EquipList holds a list of all the items of equipment owned by our customers.

I have a form mainly based on the EquipList table, with the exception that
it shows a text box for the actual price of the item rather than the code as
its more meaningful.

What I want to be able to do is to select the item of equipment that the
customer owns from a list or combo box, and then have the price field
automatically filled in according to this selection (and also have the
information in the EquipList table filled in from this box.)

Is there an easy-ish way to do it?

Thanks!

Ali
 
Top