I have 2 tables that I cannot link.
I need to take the server order # (153001 example) and convert it to 050000000000153001 which I can do.
Then I can use that number to pull the note that I need from the other table that I cannot link.
Query 1 I am pulling Service Order info from SOTABLE
in Query 1 I need to add a field that will show the 2nd note from NotesDetail table.
The fields for the NotesDetail table are NoteKey, Date, NoteItem.
In order to get the note I am after I would have to query the NotesDetail table for the following:
NoteKey = 050000000000153001
NoteItem = 000102
What is the syntax for creating a field in query 1 that will show that information?
Note: [query notesdetail where notekey="050000000000153001" and noteitem="000102"]
If it can't be done in a way that I can enter into a blank field (from design view) as I started in the previous line, how would I do it?