Help with populating fields automagically

[mihidum]

Hi,
So I have 3 tables (books, customers, sales). I would like some help with setting up my sales form. I have used a lookup field to allow one to choose customer id from a drop down list, and figured out how to use the combo box wizard to make a similar drop down box to choose a book id. I cannot figure out how to get the matching cost price of the book to appear which is stored in the books table. I would also like to do something similar with a field from the customers table for the matching customer.
I have a feeling the answer to this is pretty simple, but I've been searching for answers for a while and cannot find any

Thankyou in advance =)

[June7]

Options to retrieve the price:

1. Join the price table to the sales table in the form's RecordSource sql. Set jointype to 'show all records from Sales ...'. Bind textbox to price field and set properties Locked Yes and TabStop No.

2. Multi-column product combobox. Textbox refers to price column of combobox

3. DLookup function

Do you want to actually save the price with the sales record or just display it? If you want to save the price, need code, I use VBA. In some event, such as the AfterUpdate of product combobox: Me![Sales].Price = Me.pricetextbox

[mihidum]

Thankyou so much for the reply
I will try some of these things out and look them up