| re: Viewing table as subform and seeing linked items
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" <nospam@replytogroup.com> wrote in message
news:bqsEb.102214$%TO.12767@twister01.bloor.is.net .cable.rogers.com...[color=blue]
> MX1,
>
> Did you check to ensure that the link is set up properly (Primary key in[/color]
one[color=blue]
> table to common fields in secondary)and that the relationship is[/color]
appropriate[color=blue]
> ?
>
> Omey
> "MX1" <mx1@mx1.abc> wrote in message
> news:deqEb.82043$8y1.287257@attbi_s52...[color=green]
> > This is weird. I'm trying to make a subform on a form and have it show[/color]
> the[color=green]
> > 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[/color]
> view[color=green]
> > 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[/color][/color]
great[color=blue][color=green]
> >
> >[/color]
>
>[/color]
| 
