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?
Lookup Field Setup
Re: Lookup Field Setup
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.
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.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: Lookup Field Setup
Here is the Before SAVE
- Attachments
-
- Before SAVE
- Capture01.PNG (13.47 KiB) Viewed 1709 times
Re: Lookup Field Setup
After SAVE
- Attachments
-
- After SAVE
- Capture02.PNG (10.15 KiB) Viewed 1708 times
Re: Lookup Field Setup
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
~Paul
Re: Lookup Field Setup
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.