What is significant about it always being the 3rd related record?
Seems like your data model could use a lot of improvement--even merging the color info from these two tables into a single table.
But what you have set up will work, you just need to do the same IsValid test on both tables, not just Fabric INFO_EU.
Or there is this approach:
Let ( [ Eu = GetNthRecord ( FABRIC INFO_EU_colours::Colourway Body; 3) ;
Eu = If ( Eu = "?" ; "" ; Eu ) ;
Jp = GetNthRecord ( FABRIC INFO_JP_colourways::Colourway Body; 3)) ;
Jp = If ( Jp = "?" ; "" ; Jp )
SPEC::MARKET = "EUROPE" ; Eu ;
SPEC::MARKET = "JAPAN" ; Jp
) // Case
) // Let
Perfect! That works - thank you PhilModJunk.
Nothing significant for the 3rd related record. I used 3rd record as an example, but I copied above to make the same for the 1st, 2nd, 4th and 5th Colourway Body.