Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
tienes un ejemplo en excel/csv, de tu información que puedas postear?
I have the same question.
EDIT: This is what we are looking for: Joins and Lookups
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