2. PHPRunner General questions
  3. PHPRunner problem with using lookup
This topic is locked

PHPRunner problem with using lookup

 		11/28/2006 3:32:11 PM
PHPRunner General questions
M
 mel57 author

I have been unable to get the lookup feature to work correctly. When I go to my form to fill out, the lookup I created shows the lookup table, but when you go back to the list of records, the entry from the lookup is not there....any ideas?
J
 		Jane 11/29/2006

Hi,
please send me detailed description of what you're doing.

Also include structure of the main and lookup tables and settings you use on the "Edit as" settings dialog.

And I'll try to help you.
M
 		mel57 author 11/29/2006

Hi,

please send me detailed description of what you're doing.

Also include structure of the main and lookup tables and settings you use on the "Edit as" settings dialog.

And I'll try to help you.


Thanks for the reply, but as I was driving to the train station this morning, It came to me what I was doing wrong with the database design <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=13308&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' /> (I was paying attention to the road)..anyway, on the two fields I was trying to use the lookup optiion, I already had them in the database set as "enum" with about 70 entries listed, so that was the reason the entry from the lookup would not write to the database. I changed them to varchar and now it works great.

BTW I just registered the program the other day and it sure is a wonderful software! Thanks for the great work, and I hope you guys continue to make improvements.