Put Another Tables inside one table

[pgalvezt]

Hi, I need to associate GTO_DIC, GTO COB And INT_SUSP Inside Cartera Table. Because I need to associate the RUT field. But Without Ssnthetcs Keys.

How can I do That?

Thanks!

[pgalvezt]

Any Help?

Thanks!

[pgalvezt]

Is it Possible to do that?

[Jason_Michaelides]

Can you not just join the tables?

[pgalvezt]

Ok. I will try to do that.

Thanks!

[whiteline]

Hi.

I think you could just rename you Rut fields to test the connection of tables (don't affraid of synthetic keys if you know what you're doing).

Then, if everything's fine and works as expected, create a link table with two key fields (@id and a complex field calculated from @id and Rut) to avoid synthetic keys.

[pgalvezt]

Sorry for the delay. Ok I got Sysnthetic Keys. (The final result was I expected) But I Already have @Id as Autonumber(CodComercio,Periodo) as @Id With another 5 more tables. How can I avoid this if Autonumber just accept 2 fields?.

Thank you!

[MayilVahanan]

HI

I think for join the tables ,you mention the name like @id in tables, so synthetic key is formed..

For avoid the synthetic key, you can just rename the field @id as @idKey in two tables..

So may be the join like this:

table1

@idkey

table2

@idkey

table3

@id

table4

@id

suppose you want to join all the tables means

table1	table2	table3	table4
@idkey	@idKey
@key		@key
	@keycombine		@keycombine

in this

use @id as idKey and @key in table1

use @id as @idkey and @keycombine in table2

From this, you cn link all table and also avoid synthetic key..

I think you understand what i try to explain to avoid it..

[pgalvezt]

I`m sorry I forgot mentioned that I have another key within @id. The field is called Rut. When I renamed the field Rut for all 3 tables Cob,Dic and Sus (Matrix table is call cartera and has Rut). Synthetics Keys was created. Before This I had Rut_Cob, Rut_Dic And Rut_Sus. Here the SK didn't exist. But I needed the Rut. Let me try your technic and let you know very tanks.