Any way to use values in one table from another

Chasovskikh Kirill

Hi guys!

i have 2 tables - clients and products. 

For each row in table "clients" in column "product" i need to select one (or more) product names from table "products".

Previous time there was recommendation for plugin Orderly database , but permission settings of this plugin does not suit us.

Is there any other way to build this construction with related tables ?

Juliette Lallement _Elements Apps_

Hi @Chasovskikh Kirill 

Do you absolutely need to have two separate tables?

Could you consider two separate tabs from a spreadsheet document instead?

With the app Elements Spreadsheet , you can create lists from a selected range of cells containing values and apply these lists to one or several cells. 

For example, you can create a spreadsheet document with two tabs:

- one with clients

- one with products

From there, you can create a list from the range of cells containing your product names and apply that list to relevant cells from the clients tab. 

Would that work?

Best wishes