Hello,
I hope this is the correct location for this question. I have two separate tables that contain equipment numbers. The first is for existing equipment to be installed. the second is for the information to any repairs done to the equipment. and the third is for the replacement of the equipment. My question is how to create a query for a report that can link all three equipment numbers so the report list all the work done to that piece of equipment? I do have relationships created between the existing and the repairs to be done and if replaced.
Thanks in advance,
Ben