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

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

P: 2
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?
Jan 8 '14 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 5K+
P: 5,397
Depends on how you have things designed.
Please post your SQL for the form's recordsource
Please remember to format the SQL script using the [CODE/] button in the toolbar.

Also, I shold note, that it's not normally a good thing to store the same information in multiple tables, there are exceptions to this rule; however you might read thru:[*]> Database Normalization and Table Structures just to be sure that you are using the Database for more than just a spreadsheet. (^_^)
Jan 8 '14 #2

P: 2
Here is the SQL for the form's source
Expand|Select|Wrap|Line Numbers
  1.  SELECT tblReview.*
  2.    , tblLogistics.*
  3. FROM tblLogistics 
  4.    RIGHT JOIN tblReview 
  5.       ON tblLogistics.ReviewID 
  6.          = 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.

I don't need to store any information in multiple tables I just need the users to reference it (non editing) to complete their work in the form without jumping from form to form.

Does that make it more clear, or more muddled?
Jan 8 '14 #3

Post your reply

Sign in to post your reply or Sign up for a free account.