Having a Form Look at 2 Different Tables...

  • Thread starter Thread starter Michael Richards via AccessMonster.com
  • Start date Start date
M

Michael Richards via AccessMonster.com

I have a customer info table that has an entry form so anybody can enter
customers into it and it contains name, address, etc. Then I have a
proposal table that has quantity, part number, etc. I have created a form
that someone can enter the materials into the proposal table. But the
problem is this; I'd like to populate the customer info into the proposal
form (which has the proposal table as its data source) from my customer
table.

Thanks for your help...
 
Michael --

Try creating a query that retrieves the appropriate fields from both tables
and using this as the source for the proposal form.

HTH
 
Back
Top