I have a linked table that has "Project Number" and "DVD#" as two of the fields and another linked table that has "Project Number" and "Box Number" as two of the fieds. One database tracks all of the information stored on DVD and the other database tracks all of the archived paper documents.
I am trying to create a query that will combine the two and reflect changes to either table. I get an error message that "Project Number" could refer to either table. I need to have one complete list of project numbers combined from both databases.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.