Problem creating sales form taking info from 3 tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Have 3 tables: call them 1,2,3. I want to be able to access the info from
each of the 3 tables and add or delete items on my my new sales form with
this info from the 3 tables. Stuck creating this. Any help would be
appreciated!
 
Assuming tables are related, you simply create a query from those three
tables and pick and choose from the tables which fields you want on your
form. Depending on how you structure your query, your resultset may or may
not be updateable, so keep that in mind as it could prevent you from using
the form to update the data from the tables.

Hope that helps,
Bonnie
 
Back
Top