User Profile

Collapse

Profile Sidebar

Collapse
JMTOP
JMTOP
Last Activity: Feb 3 '14, 07:21 PM
Joined: Jan 8 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • JMTOP
    replied to How to make a textbox show information from an outside table based on a reference ID
    in Access
    Here is the SQL for the form's source
    Code:
     SELECT tblReview.*
   , tblLogistics.*
FROM tblLogistics 
   RIGHT JOIN tblReview 
      ON tblLogistics.ReviewID 
         = tblReview.ReviewID;
    tblReview refers to an ID from another table that lists general information about parts (tblWorking) the logistic guys need info from tblWorking (hence the textbox) to complete the logistics after the review....
    See more | Go to post
    Last edited by zmbd; Jan 8 '14, 05:47 PM. Reason: [z{Fixed Code.../Code tags}{Stepped SQL for easier read}]

      Leave a comment:

    • JMTOP
      started a topic How to make a textbox show information from an outside table based on a reference ID
      in Access

      How to make a textbox show information from an outside table based on a reference ID

      I have a Form that requires user updated information. It is based off a query including 2 tables. One of the tables has an ID that refers to a 3rd table. I would like to show a reference textbox from the 3rd table [partnumber] based on the 3rd table's ID from the form's record. The form view is a continuous form also so multiple records are shown at a time. Is this possible?
      See more | Go to post
      No activity results to display
      Show More
      Working...