Help with linking two columns with different names and different tables.

[Anonymous]

I got two tables, Table A and Table B, they both share a column/field called “Basesystem”.  Table A has a column called Wards and Table B has a column called teams, I want to link them together.  I can’t add Basesystems to both tables as I get a error message of creating a Circular reference etc (you guys know what I mean).

So I want to add two columns with different names in different tables linked by Basesystem, I can’t do it in the normal way as its causing the circular thing.

Thanks in advance.

[#2]

Can you provide an example of the 2 tables? According to your description, I understand that both tables already have the "basesystem" field. Or is the basesystem in a third table?

[montero91]

Hello Lakwinder,

Lo que originar es una tabla conocida como llave sintética, no es el mejor escenario pero por ser dos columnas no debe de dar problema, en caso contrario lo recomendado es realizar una unión para que quede una sola tabla, en caso de querer las dos tablas independientes, crea una llave con los dos campos para que quede un campo que las una.

Si es una referencia circular, debes de tener una tercera tabla que está generando esta referencia, para quitar la referencia es una unión de las tablas ya sea por un join o por concatenar en caso de ser dos tablas de Hechos. O quitar la columna menos relevante, para que únicamente quede tres tablas, unidas entre una tabla.

O para una mejor referencia puedes poner un ejemplo.

----------------------------------------------------------------------------------------------------------------

This is synthetic key, not the best scenario but being two columns should not give problem, it is recommended to perform a join to make it a single table, in case you want the two tables independent, create a key with the two fields so that it is a field that one.

If is a circular reference, you must have a third table that is generating this reference, to remove the reference you have make a union of either tables or concatenate a join should be two tables of Acts.Or remove less relevant column, so that only three tables left, joined a table.

Or for a better reference you can give an better example.

[Anonymous]

Base system is in both tables, there is no third table.

Sent from my iPhone