Multiple selection in a control with databinding

microsoft.public.dotnet.framework.adonet

15 Feb 2006 10:00 AM

ricbenasco

I'm developing an application where I need to let users to select from a
table (Table2) multiple values wich are relationed n to n with a another
table (Table1)

Table1<------>Table2
IdTable1 n-n   IdTable2

To make it possible in relational database theory I created a intermediate
table to break the relation n to n into two 1 to n relations. I show below a
little schema.

Table1<----->Intermediate Table<------>Table2
IdTable1 1-n      IdTable1            1-n     IdTable2
                         IdTable2

To explain better the case imagine a table where you have to select
favourites cities to travel for each customer in a travel agency, where these
cities are in a separate table.

The question is if there is a control or an assistant in Visual Studio 2005
to achieve this case of relation between three tables, I know that are
similar assistants for a relation master-detail, only two tables, but no is
my case I supose, isn't it?

Any idea will be welcoming...

Thanks on advance.