By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,849 Members | 2,339 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,849 IT Pros & Developers. It's quick & easy.

Viewing table as subform and seeing linked items

P: n/a
MX1
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
MX1
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


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.