Lookup field not showing data.
Posted: 2019-07-22 16:14
I'm using AppGini 5.76 rv.1058
Lookup field SURNAME not showing data on CSV import.
First, all tables have field "ID".
I have a table called "MARRIAGES", with a lookup field called "SURNAME", that a looks to table "ADD_SURNAME", field "SURNAME_LIST".
There are 2,656 "MARRIAGE" records I'm trying to import by way of a CSV, but as field "SURNAME" is a "lookup field" and it automatically gets set to data type (integer) the text wont import and is not looking to "SURNAME_LIST to populate.
I did import the surnames into table "ADD_SURNAMES" field "SURNAME_LIST" successfully, as there were only 16 different spellings of the same surname for the 2,656 "MARRIAGE" records.
Question; how to get data imported for table "MARRIAGES" and look to values in "SURNAME_LIST" to populate table "MARRIAGES" field "SURNAME" and still have it as a lookup field, because new spelling of surname will be added over time, there is over 25 different ways to spell the same surname.
I hope this is possible and thank you for any assistance.
Lookup field SURNAME not showing data on CSV import.
First, all tables have field "ID".
I have a table called "MARRIAGES", with a lookup field called "SURNAME", that a looks to table "ADD_SURNAME", field "SURNAME_LIST".
There are 2,656 "MARRIAGE" records I'm trying to import by way of a CSV, but as field "SURNAME" is a "lookup field" and it automatically gets set to data type (integer) the text wont import and is not looking to "SURNAME_LIST to populate.
I did import the surnames into table "ADD_SURNAMES" field "SURNAME_LIST" successfully, as there were only 16 different spellings of the same surname for the 2,656 "MARRIAGE" records.
Question; how to get data imported for table "MARRIAGES" and look to values in "SURNAME_LIST" to populate table "MARRIAGES" field "SURNAME" and still have it as a lookup field, because new spelling of surname will be added over time, there is over 25 different ways to spell the same surname.
I hope this is possible and thank you for any assistance.