Hi, Appgini is the backend for a program im making and its doing it nicely, but as the core input comes from the pc/iphone/android device the design requires something special. I need the lookup save the data itself not the key(int).
I need to to record the content of the selected lookup field as the string the user is selecting from another table.
If the person selects "from the lookup" YELLOW, and i go to mySql/MyPHPAdmin, i need to see YELLOW thee, not the number, since the SW I make its requiring it.
any help its more than welcome.
Need special behavior with Lookup
-
arcanebits
- Veteran Member
- Posts: 104
- Joined: 2018-12-10 21:52
Re: Need special behavior with Lookup
I think I SOLVED. How?
00-My mistake was that I always go and generate the Primary Key on auto, so it becomes an INT
01-As the docs say, lookups go and hunt the primary key of the parent, in my case it always took an INT value (00 step)
02-Deleted primary key from parent, asigned the value (field) i need as primary key (yep need to be unique)
03-Reconfig the Lookup, since step 02 killed it.
It seems to work
So i think i solved
00-My mistake was that I always go and generate the Primary Key on auto, so it becomes an INT
01-As the docs say, lookups go and hunt the primary key of the parent, in my case it always took an INT value (00 step)
02-Deleted primary key from parent, asigned the value (field) i need as primary key (yep need to be unique)
03-Reconfig the Lookup, since step 02 killed it.
It seems to work
So i think i solved