On what layout do you perform your find? (On which of the above table occurrences is your layout based?)
Where do you see the past tour ID's? In a portal on that layout perhaps?
I perform the find on my report. and it is based on customer order.
I don't see my past tour ID, is like when i search for the tour ID then the tour ID should appear.
These two statments appear (to me) to contradict:
when i search for tour ID, Filemaker will show up the past tour ID
I don't see my past tour ID,
Please describe, step by step, how you perform your search. What criteria you enter while in find mode and exactly what results you get.