Hi,

I have two sp queries on the same table. One returns records which have a
null ParentNavID, and the second returns records which hold the unique id
(ItemNavID) of one of the first recordset members in their ParentNavID
field.

I'm using a nested repeater to create menus in this way.

However, when I attempt to create the relationship with the following code:

        ds.Relations.Add("myrelation", _
        ds.Tables("MenuNav").Columns("ItemNavID"), _
        ds.Tables("MenuNav").Columns("ParentNavID"))

I get the error:

System.ArgumentException: These columns don't currently have unique values.

The ItemNavIDs are certainly unique, but the ParentNavID are not supposed to
be.

Help?!

Thanks,
Mike




---
You are currently subscribed to dotnet as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]

---------
Administrated by 15 Seconds : http://www.15Seconds.com
List Archives/Search : http://local.15Seconds.com/search
Subscription Information : http://www.15seconds.com/listserv.htm
Advertising Information: http://www.internet.com/mediakit/


Reply via email to