Hi all, Is there a way to make a parent reco...

(Faustin Ngassa) #1

Hi all,

Is there a way to make a parent record and its children read only? I have Sales and SalesDetails and I would like to prevent users from editing them once the date of the Sale is passed.

Thanks

(Aleksi Alkio) #2

You can’t do that in tabel level because you will have two different kind of records in that table… open and closed records. If you don’t have lot of columns, you could add an expression into option “Editable_If” like [SalesDate]>TODAY().

(Faustin Ngassa) #3

I was afraid you would say that… I was trying to avoid using the Editable_If on specific columns.

Can I disable the delete action button if [SalesDate]>TODAY() ?

(Aleksi Alkio) #4

That was just the first solution… you can create your own action buttons and then hide them depending on your record status.

(Faustin Ngassa) #5

Oh really! Ok that’s a side of things I have not explored yet, let me look that up. Thanks @Aleksi_Alkio