Iron Speed Technical Forums
Register Latest Topics
 
 
 


Reply
  Author   Comment  
daredavil

Registered:
Posts: 29
Reply with quote  #1 
Hello,
could somebody help me to pre-populate a number of text boxes within ADD page having on mind that the first step should be entering of the PIN (Personal Identification Number) upon which, the rest of the text boxes I need to be automatically pre-populated (i.e., LastName, FirstName, DOB, Address etc..). There are approximately 4 000 000 of records in the corresponding table. How to have this customization done in 9.x?

Thanks!
miles

Avatar / Picture

MVP Consultant
Registered:
Posts: 1,656
Reply with quote  #2 
it would be done the same as any other Add Record.  You will need to set the PIN # field property AutoPostBack=True, and then in the TextChanged event for this field you can set values for the other fields.  Sounds like you want to do a look up into a table to retrieve this information.  Make sure that you have taken care of indexing your database so that retrieval will be fast.

HTH,

__________________
Miles Gibson, MScIS
Iron Speed MVP
Senior Consultant, Principal
Milestone Software Inc.

http://www.ironspeedmvp.com\localizer 
Email: miles@milestone.ca
Milestone Localizer: Full Localization for your Iron Speed applications!
JimiJ

Avatar / Picture

MVP Developer
Registered:
Posts: 1,947
Reply with quote  #3 
You can use GetRecord("PIN="+this.PIN.Text) after following Miles' instruction. If you are not happy with the speed, you may look for Ajax combobox autocomplete like Telerik. 

Cheers,
Jimi J



__________________

  Jaime Jegonia
[jts_logo]

Iron Speed MVP Developer
 

". . . and whoever sows generously will also reap generously" 2 Cor 9:6

Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Download Iron Speed Designer

Terms of Service Privacy Statement