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
Why Lookup MUST be primary key?
Why Lookup MUST be primary key?
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view