Linking Multiple Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to link two queries together as a subdatasheet view. The drop
down menu shows the subdatasheet option, and you select which table/query you
wish to use. There is also two entries to indicate the fields to be linked
from one table to the other.

It turns out that I have two fields that I want to use as links, and one of
the fields always have something in it. That has no problem. The second
field may or may not have something in the field. That one is giving me
problems. The linking doesn't work correctly with the null string there. It
gives me an empty recordset, while if it didn't have that null link, it works.

I tried putting a blank in the table when its empty and it doesn't take.

Does anyone have any suggestions for me??


Thanks,

Gary
 
Open the query you have created in design view with the two sets of fields.

Click on the line that connects the fields. Double click and it opens
another window. Select the option to give you all the records from the table
that has a complete set of records. If the other table does not have a
record then it will be blank in the query results.
 
Back
Top