S
Sean Graham
I have a table that is linked to 2 separate tables. Of
course, when I click the expand to see the link, I only
see 1 table at a time. I want to see a few fields from
each, so I created a query selecting certain fields from
each table and used a union to join them together. But
now when I go to expand on the table link, it shows either
all of the records, even those that do not match the
foreign key value, or it shows nothing. A parameter field
box pops up before the link expands, too. What I want is
to be able to show information from both tables show up
when I expand the link.
Please help if you can
course, when I click the expand to see the link, I only
see 1 table at a time. I want to see a few fields from
each, so I created a query selecting certain fields from
each table and used a union to join them together. But
now when I go to expand on the table link, it shows either
all of the records, even those that do not match the
foreign key value, or it shows nothing. A parameter field
box pops up before the link expands, too. What I want is
to be able to show information from both tables show up
when I expand the link.
Please help if you can