Add initial values in field type List Ref

[thomas_c]

Hello,

I will have to work on an application in which I will have an initial form to enter data in a first table and I will have a field of type List Ref referring to a second table.

The client would like the field referring to the second table to be able to have initial values ​​in some cases.

I don't think this is possible, any idea?

Thank you 

[TeeSee1]

You can set conditional expressions in Initial Value. Try it and see if it works for you.

Make sure the expression returns a list of key values from the second table because your column is of type ref.

The below is just a screen shot of an example I tried and it seems to work fine.

[thomas_c]

Thank you for your answer but in my case I want to initialize data for future lines of references but it does not seem possible. 

[Steve]

To accomplish what you want, you need to actually add rows to the second table that would be found by the REF_ROWS() expression of the List of Ref column. These rows would need to be added before the form view is opened.

What are you trying to accomplish with this?