RecordSource Property!

  • Thread starter Thread starter gp
  • Start date Start date
G

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
 
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.
Click to expand...

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.
 
Back
Top