Hello All,
This may be an easy answer, but I have a number of tables with one field name that is consistent across all of them (not a primary key, though). My database is a personnel tracker. One table is general information, one photographs, one employment history, one address history, and one interviews. The consistent field name is an identification number assigned to each person.
How can I create a report where when I call on an identification number, the report opens up and general information, all photographs, employment history logs, address history logs, and interviews associated with that identification number appear on that one report.
Using 98
This may be an easy answer, but I have a number of tables with one field name that is consistent across all of them (not a primary key, though). My database is a personnel tracker. One table is general information, one photographs, one employment history, one address history, and one interviews. The consistent field name is an identification number assigned to each person.
How can I create a report where when I call on an identification number, the report opens up and general information, all photographs, employment history logs, address history logs, and interviews associated with that identification number appear on that one report.
Using 98
