Hi all,

Ok i have 3 tables in a dataset

Table1 contains items for sale (referenced)
Table2 contains Stores (Parent)
Table3 Contains items in a particular store (Child)

the problem is the data in this case. Table 2 contains a StoreId field as a primary key. Table1 Contains an ItemId field. My problem is in table 3 this contains 3 fields, StoreId, Name and Quantity.

Now my Table1 contains a field called Name and one called PluralName, I need to determine which field in table one relates to the Name field in table3.

The following 2 constraints exist currently in my app

Table2 - StoreId (one) to Table3 - StoreId (many)
Table1 - Name (one) to Table3 - Name (one)

can i add another constraint :-
Table1 - PluralName (one) to Table3 - Name (one) ???

I am presuming if i do i will get a constraint error as the property does not relate on a one to one level if the store has more than one item in stock and vice versa when it has only one in stock.

Any ideas how to get round this?