What value to store in lookup

[Mike Grigsby]

I'm having some problems with a form storing a field from another file. The example is like an invoice where I select the vendor (a parent) from a select popup browse. I have asked it to display the vendor name instead of the unique sysid. Looks great, but when I go back into the form after saving the record, there is no value at all. Is there anything I should be doing in order to use this functionality? The records are related in the dictionary.

[Rene Simons]

Hi Mike,

The Vendor name should be a unique key as well in the Vendor File
The unique sysid of the Vendor must be stored in the invoice.

Rene