×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
FK values in combo box when storing other ID fields
Roy Casella
New Member
Posts: 7
pred 4 rokmi 5 mesiacmi #9757
od Roy Casella
FK values in combo box when storing other ID fields bolo vytvorené Roy Casella
Hi,
When you have a situation such as
Order - Product - Product Category.
And you have done a FK field from Product to Product Category giving you Orange - Fruit Category this works fine in the Product table.
But when you then want to use the Product in the Order table and include the value for the Product Category this is then showing 1 as the ID key for Fruit Category. I totally get why it is doing this... as in the technical reasons.
But I want to know is there a trick to bring through the value of the related table i.e. Fruit Category as no-one would ever want the ID value.
It is possibly to set this up in CC.. so asking incase I have totally missed it.
Thank you
R
When you have a situation such as
Order - Product - Product Category.
And you have done a FK field from Product to Product Category giving you Orange - Fruit Category this works fine in the Product table.
But when you then want to use the Product in the Order table and include the value for the Product Category this is then showing 1 as the ID key for Fruit Category. I totally get why it is doing this... as in the technical reasons.
But I want to know is there a trick to bring through the value of the related table i.e. Fruit Category as no-one would ever want the ID value.
It is possibly to set this up in CC.. so asking incase I have totally missed it.
Thank you
R
Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.
Carl Fuentes
Moderator
Posts: 23
pred 4 rokmi 5 mesiacmi #9766
od Carl Fuentes
Odpoveď od Carl Fuentes na tému FK values in combo box when storing other ID fields
Unfortunately it is not possible to do it with Component Creator.
You will have to manually show the category
You will have to manually show the category
Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.
Roy Casella
New Member
Posts: 7
pred 4 rokmi 5 mesiacmi #9769
od Roy Casella
Odpoveď od Roy Casella na tému FK values in combo box when storing other ID fields
ok thank you for confirming so I will do my own dev
thanks
R
thanks
R
Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.
Čas vytvorenia stránky: 0.052 sekúnd