Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Concatenation is the best way to do it..and it is less confusing.
I tried a different approach with Triggers..see attached..
"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?
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
is there a problem concatenating these 2 tables?
Is there any other way
Concatenation is the best way to do it..and it is less confusing.
I tried a different approach with Triggers..see attached..