Database replationship between RG

Hi, Bubblers!~ I’m new to bubble and getting struggling with the below problem and don’t understand the logic…

If I make the table like

ITEM

  • name (txt)
    ITEM-VARIANT
  • Color Name (txt)
  • Item (Item)

When choosing one of item in RG in Item, only show reference variants in RG…

Any help is much greatly appreciated…

Hey there @sejinpk,

You can have something like:

A list of variants in your item, then when a cell in your repeating group of items is clicked, you can show a second repeating group that does a search for a custom state which lists all the variants related to the item pressed on.