0

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.

3 replies

null
    • gold_cat
    • 6 mths ago
    • Reported - view
    • Fred
    • 6 mths ago
    • Reported - view
     said:
    Can 1:N implement the conditional constraint

    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.

      • gold_cat
      • 6 mths ago
      • Reported - view

      I understand,  . You mean to make both views as shown in the example, and the second view to preview whether there are any codes that meet the conditions. Thank you for your reply.

Content aside

  • Status Answered
  • 6 mths agoLast active
  • 3Replies
  • 66Views
  • 2 Following