Unlink 2 certain tables

[theaokii]

Hi,

There is a question about data load.

I have 3 tables with the ID as key, for example

A:

ID,

Field1,

Field2

B:

ID,

Field3,

Field4

Main:

ID,

Field5,

Field3

So i want to link table A and B to the Main using ID individualy and there isn't any link between A and B by ID. It mess up the data

Could anyone give me and advice?

thanks inadvance

[lironbaram]

hi 

you can do like this 

A:

ID,

Field1,

Field2

B:

ID as IDb,

Field3,

Field4

Main:

ID,

ID as IDb,

Field5,

Field3

[theaokii]

Hi,

I'm trying to avoid this way because i cant extend the data with 2 id fields

Anw, thank you

[theaokii]

Sorry for bumping the topic.