0

I summarised my problem by a simple example,anyone plzz ans this...then I will be able to understand my problem.......:

Suppose in a database named "DATABASE"..there is a table called "XYZ"..it has 4 rows named "T1,T2,T3,T4"..one primary key named "T_id"..now what I want that to access this same table via different ids from different location but with same primary key..so I have to put some different ids also,so I give "key1_id,key2_id"..so now I have these rows in my table:
"T_id,key1_id,key2_id,T1,T2,T3,T4"

I am giving a screenshot of the table structure:
http://img11.imageshack.us/img11/4717/82031836.jpg


Now what will be the code for (add/edit/del) for these rows..I means how to access this same table via different ids from different location but with same primary key

3
Contributors
8
Replies
9
Views
7 Years
Discussion Span
Last Post by tanmoy_india
0

I added a screenshot of the table..........what I want is..onetime I access(add/edit.del) all the rows "T1,T2,T3,T4" by the Primary key T_id and key1_id....also separately access(add/edit.del) all the rows "T1,T2,T3,T4" by the Primary key T_id and key2_id............plzz tell the code

0

post your sample data and what you want to display...
so i can help you to write query

0

Can you explain what you are doing (not the table structure)? That way we can make sure the table setup is correct and there is not an easier way.

0

Can you explain what you are doing (not the table structure)? That way we can make sure the table setup is correct and there is not an easier way.

I know I cant explain properly...So I gave screenshots...i want to add/edit/del in the same 4 tables "T1,T2,T3,T4" from different point via same primary key but different corresponding key value like "key1_id" or "key2_id"

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.