NetTalk Central

Author Topic: Lookup how...  (Read 2599 times)

Nick

  • Full Member
  • ***
  • Posts: 118
    • View Profile
    • Email
Lookup how...
« on: November 13, 2013, 06:41:15 AM »
Hi,

Can't find help-text for the lookup settings:

Here the settings with what I guess is right:

Procedure:   (The lookup procedure)
Popup Lookup:   Yes (the lookup procedure is a popup netwebbrowse)
Lookup title:   (text for on the lookup-button?, not used)
From table:    (the table I want to get the value from, the same table used in the lookup procedure)
Order by:   (not sure, I would guess the order of the lookup-table, tried both)
Value Field:   (the field from the lookup table I want)

I assume the system knows where to enter the looked up value.

Tried different settings and the lookup procedure pop's up fine, I choose a record from that table
with the select button but only not relative info is put into the lookup-field. Not at all what it should be.
The lookup procedure has two one-component-keys. One for a description (country) and one for a countrycode (string(2)).
Tried both. Also tried to show the looked up table record-fields in the "After lookup.. embed but nothing shows.

Can someone tell me if these settings are correct?

TIA,
Nick

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Lookup how...
« Reply #1 on: November 13, 2013, 07:25:02 AM »
see
http://www.nettalkcentral.com/index.php?option=com_smf&Itemid=36&topic=1375.0

>> I assume the system knows where to enter the looked up value.

The looked up field (the Key used by the lookup browse) is placed in the Form Field.

you'll find an example of lookups in the Books (71) example - check out the Customer Form and the Line Items Form

cheers
Bruce

Nick

  • Full Member
  • ***
  • Posts: 118
    • View Profile
    • Email
Re: Lookup how...
« Reply #2 on: November 13, 2013, 08:07:52 AM »
yes, that's how I do it too but I had not relation between the two files and I guess that this is the problem...

Cheers,
Nick

Nick

  • Full Member
  • ***
  • Posts: 118
    • View Profile
    • Email
Re: Lookup how...
« Reply #3 on: November 13, 2013, 01:47:39 PM »
Ok, that´s working now. It was indeed the relation between these files.

cheers,
Nick