Wrong Search Results

[Tonkpills]

Hi I'm new to this forum and I was wondering if you can help me.

I'm not going to go into too much detail:

I have a database that searches a referenced file for a date range, then copies all the primary keys from the found set to a local table.

The primary keys in the local database are related to the primary keys in the referenced file.

The local database has a layout that displays data from local database (primary keys) with some fields from the referenced database (NB: The layout is set to display records from the local database).

I preform a search on that layout for:

'S01 - Warranty Replacement' and I get back blank fields, fields with the wrong info ect.

What am I doing wrong?

I have attached pictures.