Why Lookup MUST be primary key?

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts: 1156
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Why Lookup MUST be primary key?

Post by onoehring » 2019-05-22 12:48

Hi

I want to use a lookup, but NOT save the primary key of the foreign table, but another column. The pk column is integer, but the field I want to save is text.
I seem to be unable to change the fieldtype of the receiving table to text (instead of integer) - is there a way to force AppGini to follow my whishes?

As from other post of me: I need to create a cooperation between MS Access and the online world. For this reason I might (must) not use the primary key, but choose different.

Olaf

Post Reply