Registered: 1259155749 Posts: 29
Reply with quote #1
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!
Registered: 1066224327 Posts: 1,679
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.co m\localizer Email: email@example.com Milestone Localizer: Full Localization for your Iron Speed applications!
Registered: 1112254853 Posts: 1,958
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 __________________
Iron Speed MVP Developer ". . . and whoever sows generously will also reap generously" 2 Cor 9:6