Multiple Table, multiple field query with limiting records

[wally2321]

I am trying to create a table from a query using the design feature of the make query function. The following attributes are involved:

Source Table: FLORENCE_MATERIALS

Destination Table: FLORENCE SCRUBBER - MAKE

Reference Tables: X-REF VENDORS , X-REF MILK RUN

In the source table there is a field called primary vendor. I want to create a new field within the make query called "Origin Group". The complication is that the query needs to return all values, but based on the two references tables only certain values should be returned for the new field "origin group".

Is there a way to utilize the make query using the design function, and have the above senario utilizing two reference tables. I have tried linking the tables, but when doing that it only returns values that have matches in all three tables (which is not what I want to do).

Example:

Primary Vendor of 1234H exist in the FLORENCE_MATERIALS table. I want a value to be returned in the new origin field based on what value is in either the X-REF VENDORS or X-REF MILK RUN tables.

I am sorry for the confusind description, but if anyone can help, I would greatly appreciate it.

 

[wally2321]

Is there more detail that I need to provide? Please let me know?