11 replies
by sbhana
by dennisbv
The tables are tblComputer, tblPrinters, tblMonitors, tblMiscEquipment. The primary key in each one is the Asset Number.
The fields I want on the report are in all the tables and are Asset number, Description, serial, model, Location,Notes .
by dennisbv
by dr. dale
by dennisbv
by dennisbv
For answer two
I had thought of that but I don't want to do that if there is another way. The computer table has detail on the computer that the other table don't have. Thats why I went to separate tables for the different Items
by ae_maillist
Create a new table with the same columns as in ther original tables. Add a new field type.
Type can be 1 for computers, 2 for printers and so on...
Then import all the other tables into the new table.
Anders
by dennisbv
by ae_maillist
Or
use a join - query...
Anders E
by dennisbv
by dennisbv
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending