Please help - Completely Stuck!

[topcat10]

Hello all,

I'm sure this is really simple to do, however I've been banging my head against a wall trying to solve this for the past day or so.

I have a table that contains product information and price.

i.e. , Soup - £4.00, Chips - £2.00 etc etc

I have another table which users will input the product sold. The table creates a drop down using a lookup on the previously discussed table.

I want this table to generate the price dependant on what product they select

i.e. if they select soup, it will automatically fetch the correct price and so on and so on.

How do I do this?

Any help is greatly appreciated!

Many thanks.

[pbaldy]

One way:

http://www.baldyweb.com/Autofill.htm