Display information based on a condition

[Gauvainh]

Hi community,

I have two table, the first one is a database synchronised with many other, fulfilled directly by stores themself and it is creating a product list. The second table is contact information about the stores.

I would like to link phone, number and adress regarding the store concerned.

In my screenshots, green circled data are synchronised, and the red circled one are thoose I want to import from the table "ENTREPRISE INFOS".

So in "BDD ARTICLE" table, if Sync Source is "Magasin 1", I want to display information regarding "Magasin 1" in my "ENTREPRISE INFOS" table.

I didn't find any way to do it, thanks a lot for your help 🙂

[Alexey_Gusev · Accepted solution]

In 'BDD Articles', create field, linked to ENT INFOS. Your primary field of ENT INFOS must exactly match values in 'Sync Source' (for now, 'Magasin 1' != 'Magasin 1 - test' ). Then copy paste whole 'Sync Source' field into linked field, it will link with existing data, and you can right click linked field in BDD ARTICLES and add lookup fields from ENT. 
Note that if some values in 'Sync Source' are absent in ENT, it will create new records in it and link them (btw you can use it to fill the list of available Sync sources in ENT). SO you need to check whether links are correct, and do some actions, so that each new unlinked record in BDD Articles will link to corresponding shopю. For example, automation 'when records matches condition - Link is empty & Sync Source is not empty => Update Link field with the value from Sync Source'

[Gauvainh]

Hi Alexey, 

I found an other way to do it actually, FYI if you want to know 

In the customer data base, Icreated field where defaut information was set, this way each time a new line is created, info pop up.

And it will be sync in my general DB 🙂 

But thanks a lot for your time and reply!!