Hello everyone!
I hope somebody can help me with the following problem that I have. I have a
table with manuals information. Then I have several tables with the posible
owners of a manual. One of the posible owners is a company, so I have a table
with all the companies (company name, address1, zip ,etc). Another posible
owner is an internal employee of my company. So I have another table with all
the information for my employees (employee name, address1, zip, etc). Both of
these tables share common fields like address, zip, ect, so I thought about
putting both tables together although I dont wan to do that. What I am trying
to do is create a form that display the manual information and the owner
information but since the info of the owners is on separate tables, I dont
know how to make the text box to display the information coming from eigther
table. In other words, I know how to link a text box to a single table but
not to several tables. My guess is that I have to create a query, but I dont
know where to start. Any ideas?

Thanks