Related transactions
We add the Country and Category transactions and specify, in the Attraction transaction, that an attraction belongs to a country and category. We see how GeneXus keeps all related information consistent.
We add the Country and Category transactions and specify, in the Attraction transaction, that an attraction belongs to a country and category. We see how GeneXus keeps all related information consistent.
We show, in practice, the concept of referential integrity, to maintain data consistency. Introduction of foreign keys relative to primary keys and the significance of calling the corresponding attributes in the same manner. Introduction of the difference between the structure of the transaction and the associated physical table (with the concept of “inferred attributes”). Presentation of the selection list as an object automatically created by GeneXus to facilitate work with related data. We show how it is possible to indicate that a foreign key may have no value, through the Nullable property.