Page 1 of 1

[Question] Lookup Feature Display Issue

Posted: Thu Sep 16, 2021 5:55 am
by 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


Image

Re: [Question] Lookup Feature Display Issue

Posted: Thu Sep 16, 2021 6:42 am
by 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.