I think this is a tough one, I will do my best to explain.
I am pulling data from our MIS database into our internal database but first showing on a form.
I need to extract data from 2 tables in the MIS database : tblShipping and tblNotes. These tables have a one to many relationship, there can be mutliple records of notes for 1 shipping address.
On my form I need to show the all related records from tblNotes in a single string in a unbound textbox, In addition, they need to be in order. My form is a continuous form(if that makes a difference). Currently my form is just querying the tblShipping.
I feel like I may need to write a loop to grab the the multiple notes records... but I am not sure how.
[Name] John Doe
[Notes] this is
[Notes] a note
[Notes] in sequence
So hopefully have my form show
[FormName] John Doe
[FormNote] This is a note in sequence