[Question] Lookup Feature Display Issue

[jut]

So I will admit that I am new to this software and this may be an idiot box mistake of mine but I followed the instructions in the tutorial video to essentially make an invoice style template.

I utilize the Lookup feature twice to look up the person's name and their identification number.

My issue is that the data populates fine within the form but when viewing the table it populates in a weird string. I believe it to be the randomly assigned string for each data entry that nuBuilder uses. How do I get it to correctly display the name instead of this string?

Any help would be greatly appreciated

[kev1n]

Hi jut,

The foreign key is stored in the table that points to the primary key of another table. This is all about normalisation.