This topic is locked

edit records 2

4/9/2006 12:38:46 PM
PHPRunner General questions
J
jim9 author

Ok on my post titled edit records, I may have figured it out. Is this correct: When setting up the dependant lookups, the link field IS NOT the primary key field, correct? In other words, for an address, the link field would be custaddress and in the dependant area at bottom, that's where I'd use custname. Anyway this works now.
Now the second post I did (where clause), It would be neat to have a small text box next to the main dropdown box, and just before clicking the dropdown, a user could enter a search string, ie., 'DA%' just like this, and the dropdown could get all customers starting with DA. This would prevent several thousand records from being in the dropdown. Design time doesn't work for this, it's need at runtime, I think you can see why.

Sergey Kornilov admin 4/10/2006

Jim,
you are right, Link field is a foreign key, not primary.
Thank you forsharing your idea.

We plan to add a lookup helper in one of the next PHPRunner version.