Programming Microsoft Dynamics NAV - Fifth Edition

Table Relations

For the tables where we defined fields intended to refer to data in other tables for lookups and validation, we must define the relationships in the referring tables. Sometimes those relationships are complicated, dependent on other values within the record.

In Table 50003, Playlist Line, we have the field No.. If the Type field contains Resource, then the No. field should contain a Resource No.. If the Type field contains Show, then the No. field should contain a Radio Show No.. And, if the Type field contains Item, the No. field should contain an Item No. The pseudo-code (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. ...