Create new record through filtered drop down

GoMaD

Hello,

I've got the following situation:

we have a field with a table relation and this table relation is also filtered on an option type.
I'll explain through an example.

The Table relation of that field is to an Address Table with an extra filter on the Type field (Option field) to show only Addresses of the Terminal Type
Important: Terminal is not the default value of this option field!

On the page the drop down shows all the Terminal addresses.
So far so good ...

But when a user wants to create a new address of the type terminal and uses the "New" link on the drop down the default page will open but the Type field will show its default value and this means that you cannot create a address record this way with the a Type equal to Terminal.

Can this be solved in another way than writing your own OnLookup Trigger on the field?

kine

Try to set the PopulateAllFields to yes on the form...

GoMaD

Do you mean on the card that's opened when pressing new?

If so, this doesn't help.

kine

Ah, ok, I have not noticed that it is RTC and the New function, not only entering new record in the dropdown... sorry...