Form based on Database table with no record selected

Hello,

I have a need to show a form that is based on a database table with no record displayed (selected).

The default behaviour is to display the first record in the datatable/foundset.

What is the process to not show a record? I want the user to have to enter a valid key to find and display.

thx

to show, no records, in a form you can do: foundset.clear() in the onLoad or onShow… depends, on what you want…

but what i don’t understand is, you want NO records, but you want the use to have enter a valid key to find and display??

this I don’t understand

THx Harjo that worked like a champ.

In the focus lost event of the order_number element I retrieve the record they request.

I hope that is not to wierd!

Lach