I have a very odd situation in an FM12 database.
I have two tables, PubImport and BooksForImportISBN. They are related by PubImport::SKU = BooksForImportISBN::SKU13
I have a layout based on the PubImport table which has the PubImport::SKU field on it, and the BooksForImportISBN::SKU13 field on it but they're showing different data - and other fields drawn from the BooksForImport table are clearly for the wrong book.
I'm sure there is something simple I've forgotten to do - I have related tables all over the place and they're all working - but I've been staring at it for a couple of days and can't see it.
Can anyone point me in the right direction?