Hi,
Can anyone help me out with this problem?
I am creating a table within my database that contains the fields: Work Order #1, Work Order #2, Work Order #3, Work Order #4. Each record in this table represents what I call a "Reasonable Accommodation" or "RA." So every "RA," or record, can have values in any or all of these Work Order Fields.
What I am trying to do, is have the user be able to import an excel file into ONE table that contains a master list of Work Order #'s. Then, I wanted to create relationships between this imported table and EACH of those four Work Order Fields in my original table. In doing so, I wanted to create a query that would display only those Work Order #'s that were also contained in the imported Work Order File. I am finding that if I create a relationship between Work Order #1 and the Work Order Import File, I get the desired result. But as soon as I create additional relationships between, for example, Work Order #2 and the Work Order Import File, my query displays no results. Is there any way to relate this imported file to each of these four fields so that I can create a query that would display only those values that are also listed in the Work Order Import File?
Please keep in mind that I have absolutely no SQL/Visual Basic knowledge so my preferred solution would be in the basic access interface. I am a quick learner, however, so I would accept a SQL response if it was articulated well.
Thanks in advance for your help.