Yes, everything is setup fine. When I double click the table in question to
view it in data entry mode, I can see a "+" next to each row that has data.
Expanding the "+" sign allows me to see the detail in a linked table.
However, when I add the table in question as a subform in a form I work with
daily, it shows all the fields, but there is no "+" sign next to each row so
I can't drill into the detail. I need to close the form and go open the
table directly to see the linked detail. I'd love to somehow show the "+"
sign and related records from within the subform. Any thoughts?
"Omey Samaroo" <no****@replytogroup.com> wrote in message
news:bq********************@twister01.bloor.is.net .cable.rogers.com...
MX1,
Did you check to ensure that the link is set up properly (Primary key in
one table to common fields in secondary)and that the relationship is
appropriate ?
Omey
"MX1" <mx*@mx1.abc> wrote in message
news:deqEb.82043$8y1.287257@attbi_s52... This is weird. I'm trying to make a subform on a form and have it show
the entries from one of my tables. The odd thing is that when I look at the
table itself, I can see a "+" sign next to each row because the table is
linked to another table. This info is very valuable to me, but when I
view the table in a subform, the "+" sign for each row and its corresponding
detail is not there. Is there a way to do this? Any help would be
great