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

[JMTOP]

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?

[zmbd]

JMTOP:
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. (^_^)

[JMTOP]

Here is the SQL for the form's source

 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.

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?