Page 1 of 1

Lookup field not showing data.

Posted: 2019-07-22 16:14
by Jay Webb
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.

Re: Lookup field not showing data.

Posted: 2019-07-22 16:31
by pbottcher
Hi,
if I remember correctly, you need to use the integer value of the lookup for your import, not the final value.
Maybe you can try that.

Re: Lookup field not showing data.

Posted: 2019-07-22 16:48
by Jay Webb
Thanks for replying,

Do you mean use the ID# for the surname spelling in SURNAME_LIST as the value in table MARRIAGES field SURNAME?

Re: Lookup field not showing data.

Posted: 2019-07-22 17:01
by Jay Webb
Hey pbottcher!

That did it, just need to change surnames to ID# and it worked.