Look up value

[Daniel Belanger]

Good day ladies and gents

Here is my problem, I have one log where I enter manual data, a five digit
number that appear on a form. Name SERVICE TICKET.
I have another log independant of the first one where I enter my customer
calls, that contains a field that is the same but independant than SERVICE
TICKET. I have created a relationship btw the two service ticket field.

In the first log I am trying to put a button that when click will look for
the value in SERVICE TICKET and match the record in the customer call table
and print the report.

I tried d,h,vlook up, get record, find record, find next but basically and I
am sure I am missing a key bit of something, that is simple.

Thank you

 

[John W. Vinson]

Good day ladies and gents

Here is my problem, I have one log where I enter manual data, a five digit
number that appear on a form. Name SERVICE TICKET.
I have another log independant of the first one where I enter my customer
calls, that contains a field that is the same but independant than SERVICE
TICKET. I have created a relationship btw the two service ticket field.

In the first log I am trying to put a button that when click will look for
the value in SERVICE TICKET and match the record in the customer call table
and print the report.

I tried d,h,vlook up, get record, find record, find next but basically and I
am sure I am missing a key bit of something, that is simple.

Thank you

If the values in SERVICE TICKET in fact match between the two tables (hint: if
either table's SERVICE TICKET field is a Lookup field they won't!) then you
can create a new Query. Add both tables in the query window; drag the SERVICE
TICKET field from the first log to the second log, if the join line isn't
there already; select whatever fields you want to see.

John W. Vinson [MVP]