I’ve got two tables apparently in a simple one to many relationship. When I build a query and include fields from both tables information from a field on the one-side does not appear?! I just get a blank column. The one-table is also related to other tables, but these are not included in the query. Why would this happen??? Andy
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Missing field data (97)
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Missing field data (97)
- This topic has 14 replies, 5 voices, and was last updated 22 years, 1 month ago.
AuthorTopicWSandrewgibsonsw
AskWoody LoungerApril 22, 2003 at 10:54 am #386377Viewing 1 reply threadAuthorReplies-
WSHansV
AskWoody Lounger -
WSandrewgibsonsw
AskWoody Lounger
-
-
WScharlotte
AskWoody LoungerApril 22, 2003 at 12:45 pm #670338Andy,
If this is related to the same question you asked in Post 246004, it would have been better to keep it all in one thread. Without knowing how the tables are related and joined and exactly which fields you’re talking about, it isn’t possible to answer the question.
-
WSandrewgibsonsw
AskWoody LoungerApril 22, 2003 at 8:27 pm #670465This is related to the question in Post 246004, but I thought they would be two different problems. Here is the SQL:
SELECT tblSingles.SingleID, tblSingles.TITLE, tblSingles.ARTIST, tblSingles.CD_CatalogueNumber, tblPublisherShares.Publisher, tblPublisherShares.Share
FROM tblSingles INNER JOIN tblPublisherShares ON tblSingles.SingleID = tblPublisherShares.Song_ID;The field CD_CatalogueNumber shows as as blank column. If I can resolve this problem, I then have a third table called tblPositions that I want to include, which has the fields SingleID, Position, Period and Year. I hope that this makes a little more sense now?!
-
WSpatt
AskWoody Lounger -
WSHansV
AskWoody LoungerApril 22, 2003 at 9:52 pm #670484If SingleID, Title and Artist show something, there is no apparent reason why CD_CatalogueNumber from the same table would show up empty, unless there are no data in that field (as suggested by Pat), or if the name of the field is misspelled (but in that case, you’d get a parameter prompt).
-
WShasse
AskWoody LoungerApril 22, 2003 at 10:17 pm #670492Another possible silly question…
How do you manage to join two tables by using different ID’s (song single)?
In plain English: if I translate your SQL, I read: show all records for which the SONG shared by the publishers is the same as the SINGLE you talk about.
If this is no mistake (and then, I still wonderhow you could get a decent record set as a result of this query), didn’t you forget a relation table SingleSongs somewhere inbetween tblSingles and tblPublisherShares?
-
WScharlotte
AskWoody LoungerApril 23, 2003 at 2:34 am #670568Fields don’t need to have the same name in order to be joined. If they are the same datatype (or compatible, like AutoNumber and Long), then you can join on them. So it is entirely possible to have a SongID in one table and a SingleID in another and join on those fields. That doesn’t mean that they necessarily represent the same thing, but if they do then there’s nothing wrong with the join.
-
WSandrewgibsonsw
AskWoody Lounger -
WSHansV
AskWoody LoungerApril 23, 2003 at 7:35 am #670628Just grasping at straws here: do you see data in the CD_CatalogueNumber field if you increase the row height and/or column width in the query?
If not, could you post a stripped down version of your database? I hesitate to ask this, but this seems to be a bizarre problem.
- Create a new, blank database.
- Import tblSingles and tblPublisherShares and the query into the new database.
- Delete almost all records from both tables; leave only just enough to demonstrate the problem in the query.
- Compact the database (Tools/Database Utilities/Compact Database)
- Create a .zip file with the database; it should be less than 100 KB.
- Attach the zip file to a reply. Warning: if you preview your reply, you will have to re-enter the attachment.
[/list]
-
WShasse
AskWoody LoungerApril 23, 2003 at 1:01 pm #670690OK,
I agree, of course, with Charlotte. No-one is forbidden to use identical ID’s (or…) for different entities, or different name for the same ‘field’ in different tables, or even in the same table. I just don’t consider it such a common practice that it doesn’t raise any questions when there’s a join presented between two fields which by their name, if not by content, might as well indicate something rather different.
Further I agree totally with HansV asking for a small ‘postable’ extraction of your database, so that we might examine it ‘live’…
ps Just one more try: don’t you have a combo box behind the ’empty’ field referring to a wrong data source? Then, it might find no match between the actual stored data and the combo box entry data, resulting in a blanc white field…
-
WSandrewgibsonsw
AskWoody LoungerApril 24, 2003 at 11:22 am #670924I agree that the field names should be the same in both tables, but haven’t had time to revise the database (and all the attached queries etc.), although I still doubt that this would cause a problem. In response to the previous reply, I have increased the width of the field with no data.. nothing is hidden away. The CD_CatalogueNumber field is just a text field.. it’s not determined by a Lookup.
I’ll get a cut-down version of the database, but I can’t do this straight-away. I’ll post it when ready. Thanks everyone for your continued assistance. Andy.
-
WScharlotte
AskWoody LoungerApril 24, 2003 at 12:26 pm #670934Don’t worry about it Andrew. It is quite common for developers to use different key names in different tables to avoid the need to alias fields when both are present in a query. The only “problem” that is causes is that Access doesn’t automatically create joins when you drag both tables onto the query grid, which in my mind isn’t a problem at all. I generally do NOT use the same name for keys in different tables, although in my case I tend to keep a root name and give it a prefix that indicates the table. In some versions of design tools it used to be impossible to create fields with the same name in different tables because it was a violation of some stringent design concepts that required unique field names in all tables.
-
WShasse
AskWoody LoungerApril 24, 2003 at 4:07 pm #670984Communication problem.
I saw the different key names. I wondered what might be the cause. First option: just different names, but same content. OK. Won’t influence anything. No questions to be asked. Second option: there might be a relation table missing (= e.g. = song_ID+singleID+….) which could explain the different names and maybe also the malfunctioning of the query. Small chance, but you never know. That’s why I asked. Nothing more, nothing less.
As this issue about using which field names almost starts looking like a much-a-do-about-nothing-thread in this thread, and I don’t want to look like an idiot, I just want to ’round this up’. Sorry for making myself not clear enough. OK? Thanks.
-
-
-
-
Viewing 1 reply thread -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Cox Communications and Charter Communications to merge
by
not so anon
1 hour, 12 minutes ago -
Help with WD usb driver on Windows 11
by
Tex265
6 hours, 21 minutes ago -
hibernate activation
by
e_belmont
10 hours, 7 minutes ago -
Red Hat Enterprise Linux 10 with AI assistant
by
Alex5723
13 hours, 55 minutes ago -
Windows 11 Insider Preview build 26200.5603 released to DEV
by
joep517
17 hours ago -
Windows 11 Insider Preview build 26120.4151 (24H2) released to BETA
by
joep517
17 hours, 1 minute ago -
Fixing Windows 24H2 failed KB5058411 install
by
Alex5723
20 hours, 11 minutes ago -
Out of band for Windows 10
by
Susan Bradley
21 hours, 44 minutes ago -
Giving UniGetUi a test run.
by
RetiredGeek
1 day, 4 hours ago -
Windows 11 Insider Preview Build 26100.4188 (24H2) released to Release Preview
by
joep517
1 day, 12 hours ago -
Microsoft is now putting quantum encryption in Windows builds
by
Alex5723
1 day, 10 hours ago -
Auto Time Zone Adjustment
by
wadeer
1 day, 16 hours ago -
To download Win 11 Pro 23H2 ISO.
by
Eddieloh
1 day, 14 hours ago -
Manage your browsing experience with Edge
by
Mary Branscombe
19 hours, 3 minutes ago -
Fewer vulnerabilities, larger updates
by
Susan Bradley
7 hours, 29 minutes ago -
Hobbies — There’s free software for that!
by
Deanna McElveen
13 hours, 53 minutes ago -
Apps included with macOS
by
Will Fastie
11 hours, 45 minutes ago -
Xfinity home internet
by
MrJimPhelps
8 hours, 32 minutes ago -
Convert PowerPoint presentation to Impress
by
RetiredGeek
1 day, 9 hours ago -
Debian 12.11 released
by
Alex5723
2 days, 13 hours ago -
Microsoft: Troubleshoot problems updating Windows
by
Alex5723
2 days, 17 hours ago -
Woman Files for Divorce After ChatGPT “Reads” Husband’s Coffee Cup
by
Alex5723
1 day, 21 hours ago -
Moving fwd, Win 11 Pro,, which is best? Lenovo refurb
by
Deo
43 minutes ago -
DBOS Advanced Network Analysis
by
Kathy Stevens
3 days, 10 hours ago -
Microsoft Edge Launching Automatically?
by
healeyinpa
3 days ago -
Google Chrome to block admin-level browser launches for better security
by
Alex5723
22 hours, 40 minutes ago -
iPhone SE2 Stolen Device Protection
by
Rick Corbett
3 days, 5 hours ago -
Some advice for managing my wireless internet gateway
by
LHiggins
2 days, 13 hours ago -
NO POWER IN KEYBOARD OR MOUSE
by
HE48AEEXX77WEN4Edbtm
1 day, 14 hours ago -
A CVE-MITRE-CISA-CNA Extravaganza
by
Nibbled To Death By Ducks
3 days, 22 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.