Table/Query Lookup

I do not know how to find all that you ask for but here is what I have:

record source of main form - projects (the table of all proposals)
record source of sub form - customerquotedto (this is the combo table)
primary key of projects - "quote no assigned" auto generated no.
primary key of customers - "cust ID no" auto generated no.
both above primary keys are also the primary keys in "customerquotedto"

The last two items you are looking for I do not know how to get. If you can
explain how I will get them to you

Thanks

"John Vinson" wrote:

On Tue, 10 Jan 2006 14:11:02 -0800, F. M. Tom
wrote:

To do data entry, you'ld use a Form for Quotes with a Subform based on
CustomerQuotes. There'd be a CustomerID combo box on the subform to
select the customer; for a multi-customer quote you'ld just add
multiple rows.

John - The above paragraph is what I have been trying to do. I agree with
all that you have said. I have set up the "customer quotes" table but am
having trouble setting up the subform or even a form that will let me add
more than one customer to the quoted to form. This is what I am looking for
help on. - Thanks

Please post the following information:

The Recordsource properties of your mainform and subform (show the SQL
view of the query if it's a query)
The Primary Key of each table
The RowSource of the combo box (post the SQL)
The Control Source and Bound Column of the combo box

John W. Vinson[MVP]

On Fri, 13 Jan 2006 11:36:07 -0800, F. M. Tom
wrote:

primary key of customers - "cust ID no" auto generated no.
both above primary keys are also the primary keys in "customerquotedto"

That's your problem.

If the CustIDNo is the Primary Key of customerquotedto, then you can
have one and only one record for that CustIDNo.

John W. Vinson[MVP]