AppGini Community Forums

I have three tables:
Cherry -> Sort -> Ship.

I set up all my field names in the "Ship" table as lookup field to "Sort", and I set up all my field names in "Sort" as lookup field to "Cherry". If I picked an id number in the "Ship" table all the lookup field names show the correct value, but once I hit save, it saved all lookup field names saved the id number instead of the actual value.

Does anyone experience this? Am I using the lookup field too much which preventing me to get the correct value?

Hi,

not sure I get your question, but the lookup will always store the ID ( Primary Key) of the table that contains the actual value.
Maybe you can post an example.

Here is the Before SAVE

After SAVE

Yep, as @pböttcher said AG will store the id of the record, not the data itself. This makes sense so that you aren't storing data multiple times. You get the bonus that if you change the data, you change in one place and it changes in all references.

~Paul

Hi,

I think this may be related to

viewtopic.php?t=3618

That seems to be a bug