Hello Ingo, Yes, now makes sense. Many thanks, you’re always a great help.
Regards, Emad > On 27 Mar 2022, at 7:30 PM, Ingo Wolfmayr <ingo.wolfm...@wolfix.at> wrote: > > Hello Emad, > > why does GEO_ASSOC not help. This is the table that links them together. > > For example: > > The GEOs Austria (AUT), Germany (GER), France (FRA), ... are part of the GEO > (EU) european union. > EU << AUT, GER, FRA > Vienna is the capital city of Austria. > AUT << VIE > You can also define theoretical regions for your transport company and > shiping calculation. > AUT, GER (Region 1): REG1 << AUT, GER > FRA (Region 2): REG2 << FRA > > So for example AUT can have multiple parent GEOs. > > GEO_ASSOC_TYPE defines the type of the relation. > > Best regards > Ingo > > > > Am Sonntag, 27. März 2022, 15:24:52 CEST schrieb Emad Radwan: > > Hello Community, > > > > I understand that with Both Geo and Geo_Type tables I can create - for > > example - a country and state, however, linking them together isn’t clear, > > there’s no parent-child relationship in Geo, and demo data in Geo_Assoc > > table doesn’t help show a clear example. Would you please elaborate on > > this? > > > > Regards, > > Emad > > -- > Mag. (FH) Ingo Wolfmayr > Wolfix Solutions > Gänsgasse 14 > A-5282 Ranshofen > > Tel.: +43 (0) 664 2549626 > Web: https://www.wolfix.at > https://www.xing.com/profile/Ingo_Wolfmayr/ > www.linkedin.com/in/ingo-wolfmayr > <emailsignatur.png>