@Corc22,

When creating a custom field, you have the ability to create persistent - reference type custom fields. Just create a persistent custom field and select the ‘reference’ as data type.

Under the reference window, you can provide logical unit information. Anyway, there is no option to write a select expression with this combination.

Is that what you want?

If I understand correctly the request is to have a Reference type field so that the user can select a value, but then also make that value/field so that it can be manually entered into with presumably a non-list value.

I don’t think this is possible since it generally defeats the purpose of a lookup field value, but I do understand why it might be wanted in some situations.

Nick

Thank you both for your time, I tried the first option, but this still doesn’t let enter a non-list item.

@NickPorter agree, but I thought I’d ask in case there was a clever workaround. 

Thanks and all the best

Rob

Try a Persistent field that defaults to a referenced value. You can do this by creating a “BEFORE INSERT” Oracle trigger.

CREATE OR REPLACE TRIGGER c_default_field_x_tib

BEFORE INSERT ON my_custom_logical_unit_clt FOR EACH ROW

DECLARE

BEGIN

   :NEW.cf$_field_x := ifsapp.some_api.some_function();

END c_default_field_x_tib;
 

Hi @Corc22 

I know I am too late, but If I am understanding your requirement correctly, you need a persistent field with a default value set using a ‘SELECT...’ statement, am I right?

If this is the case, you can set Default Value when you create a persistent field. Select a ‘PLSQL Expression’ and type your SELECT statement -
 

Thanks.