0

Relation 1:1

Hello,

I have a table and for this one i need copose with another tables. But all other table must have maximum 1 record for the parent table. My question is : how can do relation 1:1?

Thanks 

Robert

1 reply

null
    • Mconneen
    • 5 yrs ago
    • Reported - view

    @Robert... If understand you correctly...   You want  a master table.. a child composite table.. and ensure the child has one and only one row.???? 

    dataModel

    Create a view and a button on the master (aka parent) form. 

    master

    Hide the default table/relationship link by setting it Display if to false. ... Then add a View for the child.   This shows the child but does not let you add.

    ChildAsView

    Put logic in the button to display only if the child count is zero.   For the formula.. create a Child and assign the current master as the owner. 

    buttonToCreateChild

Login to reply

Content aside

  • 5 yrs agoLast active
  • 1Replies
  • 1609Views