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 [1] -------- [1] emailsignatur.png