473,320 Members | 1,865 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Viewing table as subform and seeing linked items

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
2 1441
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: mm nn | last post by:
Hi, I want to create a table like this: ID Autonum Datefld Date Cat Text Itm Text tCount Number
6
by: Pat | last post by:
Hello, Two questions - hence the weird subject. First, anyone had luck with the Enumerating user accounts in a NT Domain module by Dev Ashish on Access Web...
0
by: MX1 | last post by:
Hi, I have a table (tblA) with a linked detail table (tblB). When I view the contents of tblA in data entry mode, I see a "+" sign next to each row. If I click to expand the "+" sign, I can...
4
by: Laura | last post by:
Here's the situation: I'm trying to use an update query to copy data from one row to another. Here is the situation: I have 5 companies that are linked to each other. I need to show all 5...
8
by: Smartin | last post by:
I have a form in Access97 which facilitates a query against a production Access database. Users will enter some search terms and see a datasheet view of the results in a subform. The prod table is...
4
by: sparks | last post by:
I am trying to fix a database that someone did about 4 yrs ago in access97. The main table just contains demographics and is on the main form of the database. It has a subform on a tab that...
7
by: john | last post by:
In my form I have a master table and a details table linked 1xM. I can search through the whole parent table but I also like to be able to search through the child table fields to find parent...
3
by: wvmbark | last post by:
First time poster... I just found this forum and it appears there's plenty of people here that could make short work of problem that's been driving me absolutely bonkers for months. Every day we...
3
by: Robert McEuen | last post by:
Using A2K3, Windows XP I'm handling a many-to-many relationship with a linking table structure as follows (irrelevant fields omitted): tblIssue PK_IssueID (autonumber, primary key) IssueName...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.