Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Join Key of "* Tbl" not in Record Set

Join Key of "* Tbl" not in Record Set

Join Key of "* Tbl" not in Record Set

I have pulled all of the fields from two tables into a query and designed a form using that query and I get stuck on "Join key of "*.Tbl" not in Record Set. Can't seem to find anything in the help files. Can anyone suggest a good book on Access 2000?

RE: Join Key of "* Tbl" not in Record Set

Paste the SQL into a reply.

RE: Join Key of "* Tbl" not in Record Set

SELECT [caseid] & " - " & [casesub] AS CaseNumber, [Submissions Tbl].CaseID, [Submissions Tbl].CaseSub, [Submissions Tbl].SubmitDate, [Submissions Tbl].[Submitted by], [Submissions Tbl].SubmReport, [Owner Tbl].CustomerID, [Owner Tbl].CompanyName, [Submissions Tbl].OwnReport, [Owner Tbl].PhoneNumber, [Owner Tbl].FaxNumber, [Invoice to Tbl].CustomerID, [Invoice to Tbl].CompanyName, [Submissions Tbl].InvReport, [Invoice to Tbl].PhoneNumber, [Invoice to Tbl].FaxNumber, [Invoice to Tbl].BillingAddress, [Invoice to Tbl!City] & " " & [Invoice to Tbl!Stateorprovince] AS [City Prov], [Invoice to Tbl].PostalCode, [Submissions Tbl].Prelim, [Submissions Tbl].VetID, [Vet Tbl].VetName, [Submissions Tbl].Add, [Submissions Tbl].SpecimenID, [Specimen Tbl].Specimen, [Specimen Tbl].Class, [Specimen Tbl].Age, [Specimen Tbl].WDM, [Specimen Tbl].Sex, [Specimen Tbl].Dead, [Specimen Tbl].Alive, [Specimen Tbl].BarnFloor, [Specimen Tbl].Size, [Specimen Tbl].Mortality, [Specimen Tbl].Morbitity, [Specimen Tbl].Feed, [Specimen Tbl].Medication, [Specimen Tbl].Vaccinations, [Specimen Tbl].Signs, [Specimen Tbl].Other1, [Specimen Tbl].Serreq, [Specimen Tbl].OthReq
FROM [Invoice to Tbl] INNER JOIN ([Specimen Tbl] INNER JOIN ([Vet Tbl] INNER JOIN ([Owner Tbl] INNER JOIN [Submissions Tbl] ON [Owner Tbl].CustomerID = [Submissions Tbl].Owner) ON [Vet Tbl].VetID = [Submissions Tbl].VetID) ON [Specimen Tbl].SpecimenID = [Submissions Tbl].SpecimenID) ON [Invoice to Tbl].CustomerID = [Submissions Tbl].[Invoiced to];

RE: Join Key of "* Tbl" not in Record Set

SQL looks ok.

The only thing I can think of is that the software is getting confused over the table names as there are spaces in the names.

If you are not too far down the line with the database, rename in a similar fashion to the following:

submissions tbl becomes tblsubmissions
invoice to tbl becomes tblinvoiceto

and so on - generally use tbl or qry or frm as the first 3 letters and follow it with a description with no spaces.

Failing that, we could be looking at an early prize for wanting Office 2000 Professional Service Pack 1...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close