Related tables not working properly

Discussion created by AlastairMcInnes on May 10, 2016
Latest reply on May 10, 2016 by AlastairMcInnes



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?