First of all, sorry for translating the need for help on Google Translate.
I’m studying making an app store. There is 1 set of shoe products. 1 set of shoes consists of different colors and shoe sizes. I want the application to display a list of shoes when I select the desired item by selecting the shoe color. and show the image of the item I selected, for example, choose the color of red shoes The picture will show the color of the shoes is red. If you choose another color of shoes The picture also shows the shoe color that has been selected.
I don’t know what to do. Or is there an example for me to copy and learn more about?
You would have to structure two tables for this: Products & Product Variants.
Products table
| RowID |
Product Name |
| abc |
Product 1 |
| abd |
Product 2 |
| abe |
Product 3 |
Product Variants table
| RowID |
Product ID |
Variant Name |
Variant Image |
| v123 |
abc |
Variant 1a |
Image link |
| v124 |
abc |
Variant 1b |
Image link |
Then create a relation using the product ID to get all variants of a product, and use it in a choice component writing to a user-specific column, write the rowID of the variant.
Use the rowID that was chosen to create a single relation to the Variants table and retrieve whatever info you need, including the image, to display.
2 Likes
Try doing as you told me. Is it like this?
Why doesn’t an image of the selected product appear when I click on a product in the choice component?
Did I miss any method? 
You’re writing the choice to a user profiles column. If you want to do it that way, you have to create the relation from the user profiles table to grab the image.
I would suggest writing to a user-specific column in the Products table instead. Then use a relation - lookup to pull the image and display it in your Image component.
Sorry, the system cannot display the images for the selected item.
Can I message you?
What column are you pointing the image component to?
Please keep the discussion here so if I’m not available, someone else can chime in.
I choose Products Variants table
according to the attached file:
The table that I drafted
Or is there an example where I can copy the template? 
@ThinhDinh From your method Now I can select a product(color) and display images based on the selected product(color). But I still have to change the column ProductsID name to something else for the option to show.
I don’t know if there is a way that doesn’t require changing the column ProductsID.
I don’t understand this part. Can you elaborate more?
@ThinhDinh I mean Your method can now display images based on the selected items. But it is not classified as a type of product. The created items will be displayed as product variants of Products 1 and Products 2 in the Choice Component (if I add product variants of Products 1 and Products 2 to the table). I want the products to be listed by category. For example, if I click on Category Product 1 will display product 1 variants in the Choice Component, without Product 2 variants included.
If you have constructed the Product Variants table correctly, from the Products table, you can create a muiltiple relation to the Product Variants table to retrieve only related variants and use that as a source for your choice component.
