model?

[Anonymous]

i have  3 tables

i want develop data model here

as per my req is i want concatenate all tables but it is not showing relation ship between the fields ?

is there any way to do this ?

when i put listbox for each field data is there

when i go for table box with multiple fields or checking datamodel using preview it is showing like '-' this symbol(null)

but when i go with listbox it is showing complete data

what is problem here

why concatenate is not working ?

[robert_mika]

Do you have any common column name within your tables?

Let say this will concatenate:

t1:

load * Inline

[

no

1

2

3

4

5];

t2:

Load * Inline

[no

1

2

3]

but this not

t1:

load * Inline

[

no

1

2

3

4

5];

t2:

Load * Inline

[number

1

2

3]

[Anonymous]

but here i have only one common field

between table1 and table2

other than that i dont have any common key

[robert_mika]

Is possible to create synthetic key ,could you post your data?

[NickHoff]

Concatenate won't work unless you have the same table structure in each table.  You'd be better off joining the tables into one based on your key fields.