add a conditional constraint
Can 1:N implement the conditional constraint function shown below in the "视图"? I want to make the code of Products2 in Orders the same as the "The Warehouse" of the order. I can only think of a 1:N way, because ChildTable and GrandChildTable must be related.
As you see there is no contraints part of a reference table. It is already constrained to only show linked records. You can further filter records by showing appropriate fields in the columns and then filtering through the column.
You can also add a view table and then you can show anything you want.
- Status Answered
- 2 wk agoLast active