Hello!
As you can see in the picture below, I have only got three tables that actually are suppse to store data. My Material is sometimes being moved around between different contractors and different jobs. My Employer wants the information on the previous job and the previous job retained, to on item in the material list can have several jobs assigned to it. So far it is a simple many/to many relationship.
But how do I display the information in two different fields in a query/form? Is my design of the database appropriate for this?

Please help a newbie to Access!

Picture of the ERD to be found here

Cheers



Chris

PS: I am using Access 2003 here.

PPS: I dont know where to put this, but I think, since it is more about the database design than the actual querying technique it should be okay here. (?)