Why Lookup MUST be primary key?
Posted: 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
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