|
-
February 2nd, 2007, 07:36 AM
#1
Two Parent and one child DataRelation , Is it possible?
I have 3 tables [ tblItems , tblUser , tblUsage]
tblItem [ ItemId , Item Name , Description ]
tblUser [ UserId , UserFirstName , UserLastName ,........]
tblUsage[ ItemId , UserId , BeginDate , EndDate , ..........]
I need to create a relation of such tblUsage as child of two parents ( tblItem and tblUser ) but when i create its relation then it gives me error like "Cannot create a Key from Columns that belong to different tables."
Is it possible or not. . Any suggestions would be appreciated.
Thanks in Advance.
A Person who is polite is given goodness and a person who is away from Politeness is away from Goodness.
NAUMAAN
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|