For the tables where we defined fields that are intended to refer to data in other tables for lookups and validation, we must define their relationships in the referring tables. Sometimes, these relationships are complicated and are dependent on other values within the record.
In table 50103, Playlist Line, we have the No. field. If the Type field contains Resource, then the No. field should contain Resource No.. If the Type field contains Show, then the No. field should contain Radio Show No.. Finally, if the Type field contains Item, the No. field should contain Item No.. The pseudocode (approximate syntax) for that logic can be written as follows:
IF Type = 'Resource' THEN No. := Resource.No. ELSE IF Type = 'Show' THEN No. := Radio Show.No. ELSE IF Type = 'Item' THEN No. := Item.No.
The syntax to put in Visual Studio Code is displayed in the following screenshot:
Table 50004, Playlist Item Rate, has a similar TableRelation...