✏️ Explanatory Question
How many types of relations are available in Axapta, Explain each of them.
Normal Relation: enforce referential integrity such as foreign keys. For displaying lookup on the child table.
Field fixed: works as a trigger to verify that a relation is active, if an enum field in the table has a specific value then the relation is active. It works on conditional relations and works on enum type of data.
Ex-Dimension table
Related field fixed: works as a filter on the related table.it only shows records that match the specified value for an enum field on the related table.