How to code an inteligent memory form?

[jorgemir]

Hi-
I want to code a memory form where the user insert his phone number and the form lookups this number in the database. If it exists, shows the customer's info. If the customer does not exist, the waits for the customer's data and then saves it into the database. This only form is getting me crazy. I can not get the data, nor can get the form inserts the data into the database. It is very difficult wihout a description of the methods or the precise way to do things int NT. I can not for example, get the memory fields that I know has data written into the data fields. This is very confusing.
Thanks-
Jorge

[kevin plummer]

Hi Jorge,

Here's a stab in the dark at what you could do.

This should be a memory form.

On the phone number field, send the value to the server. Add your server side code. Make sure you open the file, set it to use and close it after you finish your lookup. In your code update the customer details into SSV's that display on the page. Add these fields to the refresh list after the server side code runs. I would also add a button to insert new details if they didn't exist and hide this button if values did exist. For the insert button add some server side code remembering to open, use and close the file.

HTH's

Kevin

[jorgemir]

YES.
Ok. I did it.
Your help was very valuable. Trick was the SSV. I was doing the mistake using directly the memory fields. I had to put them into the session in order to get used by the filemanager.
Thanks a lot, Kevin.
Jorge