AlastairMcInnes

Related tables not working properly

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

Hello,

 

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?

 

Thanks,

Alastair

Outcomes