Data Model

[#1]

Hello All,

I have 2 tables,which are linked by a field say Key

Eg Table 1 has following fields

Key

Statements

Sub Stamenents

Sub statement 1

Sub statement 2

and many other fields

Table 2 has following fields

Key

S_Statement1

S_Sub Statements

S_Sub statement 1

S_Sub statement 2

and many other fields

i want to have  field say Statement .When i click on this statement the it should get all the values for Statements and S_Statement1

Similar for all the statements below.

Link table does not work fine,linking between the two tables fail..how can we resolve this problem.

Thanks and Regards,

Priya

[phaneendra_kunc]

"i want to have  field say Statement"

This means you will have a third field which is not related/doens't exists in above 2 tables.

What king of data is in your field "Statement"? if it is similar to the data that is available in Statements and S_Statement1?

if so then we can use triggers to achieve that...

so many assumptions...   can you through a sample app?

[#3]

Actually the two tables belong to two different database and has only link on basis of key.the statements and S_Statement1 are similar kind of data..

So What i want is all the values in statements and S_Statement1 should be i one field  so that on one click i get values from both the database for that particular statement

[phaneendra_kunc]

is there a problem concatenating these 2 tables?

[#5]

Is there any other way

[phaneendra_kunc · Accepted solution]

Concatenation is the best way to do it..and it is less confusing.

I tried a different approach with Triggers..see attached..