RecordSource Property!

[gp]

Hi,

I have a main form " createquote". I want some of the
fields' record source to be one table - quoteheader and
some other fields' record source to be customer table.

Right now I make the entire form's record source as
quoteheader table.

How can I do this?

I would appreciate any ideas
Thanks in advance

 

[John Vinson]

I have a main form " createquote". I want some of the
fields' record source to be one table - quoteheader and
some other fields' record source to be customer table.

How are the quoteheader table and the customer table related, if at
all?

You can either create a Query joining the two tables and use that
Query as the form's recordsource, or (more commonly) use the "one"
side table as the recordsource of the main form and the "many" side
table as the recordsource for a Subform.