Lookup with multiple relation

Hi all,

I have two tables :

  1. Model and Price for Model
    Eg :
  • Super Lift = $100,000
  • Super Tower = $50,000
  1. Model Options to add on “Options Price”
  • Super Lift = Boom = $200
  • Super Lift = Gated = $100
  • Super Tower = Boom = $300
  • Super Tower = Gated = $50
  • Super Tower = Foot Brake = $450

For example, User can choose Super Lift with no options.
and also, User can choose Super Lift with Boom .

My question how, to make a lookup for Options Price with two relations (Options and Model).

I’m thinking you would have a relation for model, where you pull back the price for model, and a relation for options, where you pull back the price for options. Then you add them together in a math column.

but i need to do in first sheet.

plus, the options itself got same name but different price. so it is dependent on two relations

Oh you’re right. Then what I would do is have a structure like this.

Model | Options | Price
Super Lift | (Empty) | $100,000
Super Lift | Boom | $100,200
Super Tower | (Empty) | $50,000
Super Tower | Boom | $50,300
Super Tower | Gated | $50,050
Super Tower | Foot Brake | $50,450

Then join the model and options together in a template column. Let’s say it would be:

Super Lift & (Empty)
Super Lift & Boom…

Join the user’s model choice and options together in another template column, then make a relation between the two templates column and bring back the total price.

1 Like

Hmm i dont think it is easy because Its about thousands data,

Is there any ways to do ?

You would still have to create two relations if you want to keep the current structure, I believe you’re having 2 sheets.

First relation points the user’s model choice back to the Models sheet, returns the price of the model.

Second relation uses the template as described above to the Options sheet with another template column, also described above, to return the price of the option.

Then a math column to sum the two lookup results.

1 Like

I dont think that you understand my problem.

I need to do the process on the first sheet. ( Model and Price for Model)
The problem is , I make the model relation and option relation but how can I make a lookup as two condition (model and options) is filtered.

What is your desired end result?

Why can’t you use the template method? It’s only a couple of columns and it automatically populates with data. It doesn’t matter how many rows of data you have. Your second option relation will use the template columns.

1 Like

The issue, as I see it, is that your options are unique to each Model.

If the Options were the same price you could do it with a lookup to an options table, however with each option being a unique $value you are essentially creating individual products.

You can still filter the product choices and the options, but that is done one the design side within the choice dropdown (or however you decide to access each product).

Hi @biha, I think, if you see this guide probably you can resolve your question… (relation Parent&Child) … Subcategories + Hierarchies - Glide Library