Method Community

I have a custom table that includes a Customer dropdown that displays the Customer Full Name on the screen as the select options.

I'm trying to do a data import into my custom table based on Customer RecordID but the import says it can't lookup the value based on the ID.

Why not? It seems weird that exporting my custom table includes the Customer_RecordID field, but when I attempt to import and add records to the table, I can't use the numeric Customer Record ID field but rather a text value that can change?

What am I missing? Does my issue make sense?

Argh. I understand now...I had some wonky table fields and associations, left over from when I first created the screen. I think I understand how all the data is stored now and should make my data import a little easier.