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?