NetTalk Central

Author Topic: lookup problems  (Read 2814 times)

ccordes

  • Sr. Member
  • ****
  • Posts: 384
    • View Profile
    • Email
lookup problems
« on: September 28, 2010, 10:45:24 AM »
I have a browse of orders and a form.
When I insert anew order, I use a lookup for the customer Id. I have the display description instead of code box checked.
I also do the same for the item being ordered.
everything seems to work fine until I save. Then the custumer record gets cleared and so does the order cusid.
If I uncheck display description, it saves OK.
The inventory item look up works fine! Shows the description and saves the Id.

Any guesses as to why this might be happening?
All the id fields are single auto-incremented longs.

chris
Real programmers use copy con newapp.exe

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11244
    • View Profile
Re: lookup problems
« Reply #1 on: September 28, 2010, 10:51:46 AM »
Nothing springs to mind.
Does the "lookup" tables have a unique, single component key, on the _description_ fields?

Do the examples work? (I think Example 31 has the most lookups.)

Cheers
Bruce

ccordes

  • Sr. Member
  • ****
  • Posts: 384
    • View Profile
    • Email
Re: lookup problems
« Reply #2 on: September 28, 2010, 10:59:27 AM »
Key on description? cus:code - yes.
I haven't retried the samples, but the item lookup in the same procedure works.
When I hit save, the customer record is cleared as well as the order cusid. Everything else is untouched.
I originally had this going to a payment page but have taken that out of the URL on Save.

Real programmers use copy con newapp.exe