FK values in combo box when storing other ID fields

FK values in combo box when storing other ID fields

3 months 4 weeks ago #9757 by 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

Please Log in or Create an account to join the conversation.

3 months 4 weeks ago #9766 by Carl Fuentes

Unfortunately it is not possible to do it with Component Creator.
You will have to manually show the category

Please Log in or Create an account to join the conversation.

3 months 4 weeks ago #9769 by Roy Casella

ok thank you for confirming so I will do my own dev

thanks

R

Please Log in or Create an account to join the conversation.

Time to create page: 0.140 seconds
Powered by Kunena Forum

We use cookies so that you can place orders and we can provide a better service. You can control the use of cookies at the individual browser level. If you reject cookies, you may still use our website, but your ability to use some features or areas of our website may be limited.