Condicional lockup

[Dani R]

Hello to all

 

I have to layout that his date of a main company  and i have a layout of the branches.

 

in the main company there is record named lockup  that is  off or on.

 

i what that if the  main company the lockup filed is = "yes"  then in layout branches it will lockup from filed price.

but if in layout main company the lockup filed is = "No" i will be able to enter a price @ the Brach layout.

 

 

Thank you

Dani

 

 

 

[MarkWilson]

A number field with a calculated value of If( lockup = "yes" ; Lookup( RelatedTable::price ) ; "" ).

[Dani R]

Thank You Very Much.

 

Small question , it work when i create a new record, but in a existent record how can i prevent that it will not be able to changed if lockup ="yes".

 

thanks Dani

[Lee Smith]

You should use a script to for a Re Lookup and NOT have it part of a different script.

[Priyabrata]

You can relate the MainCompany and the branch table including a relationship from the Maincompany::Lockup=Branches::Lockup (calculated field value= "NO")