Access & Query (2 parent tables)

B

bldink (Brad L.)

I have a problem. Our, my department's, Access 2003 database has 2 MAIN
tables ("Company Assets" and "Employees") and a sub-main table linking the
two, "Asset-Employee_Link". I am able to set it up where the
"Asset-Employee_Link" table is parent to the other two tables when making the
database the main data connection. Well when I do this I loose access too
all of the assets and employees (by asset number and employee number) that
are not in the "Asset-Employee_Link" table. Is ther a way to make Infopath
have 2 or more main tables and have others subbordinate to them?

All forms of input are welcome. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL query with join on substring 5
List all tables, including document structure 0
Help creating a search form in Access XP 0
Table Security in Access 2013 1
TreeView Query and or Queries Question 4
Filling infopath Form with existing values from SqlServer 0
Charting Missing data accross three related tables by region and % 1
Access 2013: Form problem in reading data tables; relationship one-to-one 0

Top