relationships between multiple tables

[#1]

I have several tables that are related to each:

Nivel 1

id nivel 1

id compañia

id division

descripcion n1

Nivel 1-2 (relates Nivel 1 with Nivel 2)

id nivel 1

id nivel 2

id division

Nivel 2

id nivel 2

id division

descripcion n2

Nivel 2-3 (relates Nivel 2 with Nivel 3)

id nivel 2

id nivel 3

id division

Nivel 3

id nivel 3

id division

descripcion n3

need to relate everything to another table

Table Presupuest

id compañia

id division

id nivel 1

id nivel 2

id nivel 3

debito

credito

I intet to the relationship in different ways but not working as it should,

please help

[#2]

tienes un ejemplo en excel/csv, de tu información que puedas postear?

[#3]

I have the same question.

EDIT: This is what we are looking for: Joins and Lookups

[chiru_thota]

The main issue here is synthetic keys.You can try two way here

(1) Concatenate all the tables.It will work fine

(2) Rename columns which you think not common between tables.

(3) You can concatenate the columns and come up with composite key to have relation ship.

Thanks,

Chiru