Table Join Help

[Jonesy]

Hi, I am developing a database in Access. They have many clients who have set rates. They quote for many different contracts but when they quote the set rates need to flush in automatically on selection of the client so the administrator just needs to add the new contract then add quantities to the list of set rates. This then produces a quote by selection of the QuoteID.
This process works fine apart from getting the set rates to flush in everytime you create a new quote.
How do I set this up, and where should the quantity fields sit??
Thanking you in anticipation, Jonesy

[June7]

Sounds like clientID is the linking key. You need another table that associates quote with rates. This 'junction' table would have fields for quoteID and rateID and Quantity. Code could create a set of rate records with the quoteID and rateID already filled in and then present them to the user to fill in the quantity but this can be complicated. The conventional data entry approach would be a subform bound to the junction table and linked to the quote form and user selects the rate from combobox and enters quantity.

[Jonesy]

Thank you Super Moderator, sometimes you need someone who knows just to spell things out, I'll give this ago and let you know how I get on! Cheers chap, Jonesy