John Halls
John_Halls
Somerset, England
Joined: Thu Feb 11 10:04:26 UTC 2021
Latest Posts
-
Re: Hi, I have a Materials Table that has a sub-table with different costs by Suppliers. Now I'm creating a Purchase Order and selecting the Material in the line item and I would like to populate the proper cost by matching the record with the Purchase order Supplier. can anyone help me with the proper select syntax ?
Hi Rocco Your data model should look something like this In the Lines table the Trigger after update can have something like The fields ending ID are my reference fields. Regards John -
Re: Why is the "constraints" feature available only in 1:N relationships and not for the N:1 relationships ?
You are right, constraints are super useful. When you are on the child selecting a parent, that parent can already have been linked to a different child and it's still available to add to child you…