5 Replies Latest reply: Nov 11, 2014 1:28 PM by Jarl van den Berg RSS

    Linking Tables (loop)

      Hello community,

      Attached you find a file with the table view of my tables.

      There are two main tables: Customersheet and Hatcherysheet.

      The customer sheet got a field: CLIENT, however the hatcherysheet got 5 fields with CLIENT (1CLIENT, 2CLIENT, 3CLIENT, 4CLIENT, 5CLIENT). I created a Crosstable of these five fields to create one: CLIENT.

      When I run the script it gives me an error that this crosstable is 'loosely' connected, which basically means it isn't

      How do I get the field CLIENT to match with those crosstable directly, or... option 2, how do I get CLIENT field in the CustomerSheet to be linked to the 5 fields mentioned above?

      Cheers guys!