![]() |
Sergey Kornilov admin 11/23/2006 |
You need to use User can see and edit their own data only security mode. |
V
|
vlree author 11/24/2006 |
You need to use User can see and edit their own data only security mode. Use this mode for all tbl Member, tblContact and tblMemberContact tables choosing correct owner id field. For more info see http://www.xlinesoft.com/asprunner/docs/ad...ty_settings.htm 2. Users can see and edit their own data only This option allows to restrict users to view and edit their own records only. To use this option you need to set a relationship between table that holds usernames and passwords and main data table.
|
J
|
Jane 11/24/2006 |
You can send it to the [email=support@xlinesoft.com]support@xlinesoft.com[/email]. |
V
|
vlree author 11/24/2006 |
You can send it to the [email=support@xlinesoft.com]support@xlinesoft.com[/email].
|
V
|
vlree author 11/27/2006 |
Ok I am still trying and not successful - SELECT dbo.tblMemberContact.MemberContId, dbo.tblMemberContact.MemberId, dbo.tblMemberContact.ContactId, dbo.tblMemberContact.PrimaryContact, dbo.tblMemberContact.Board, dbo.tblMemberContact.Emergency, dbo.tblMemberCompany.MemberID AS m, dbo.tblMemberCompany.CompanyName AS companyname, dbo.tblContact.ContactID AS contactID, dbo.tblContact.FirstName, dbo.tblContact.LastName FROM dbo.tblMemberContact INNER JOIN dbo.tblMemberCompany ON dbo.tblMemberContact.MemberId = dbo.tblMemberCompany.MemberID INNER JOIN dbo.tblContact ON dbo.tblMemberContact.ContactId = dbo.tblContact.ContactID WHERE (dbo.tblMemberCompany.MemberID = 467)
Item cannot be found in the collection corresponding to the requested name or ordinal.
|
![]() |
Sergey Kornilov admin 11/27/2006 |
You cannot update multitable join query. There is no need to use join query in this scenario. |
V
|
vlree author 11/28/2006 |
You cannot update multitable join query. There is no need to use join query in this scenario. Use "Users can see and edit their own data only" security mode to link tblMemberContact and tblUser tables. Create a master-details relationships betwen tblMemberContact and tblMember and between tblMemberContact and tblContact tables. This is it.
|
![]() |
Sergey Kornilov admin 11/28/2006 |
Send your password to support@xlinesoft.com. |
V
|
vlree author 11/28/2006 |
Send your password to support@xlinesoft.com.
|
![]() |
Sergey Kornilov admin 11/28/2006 |
Answered to your personal email. |