I have somethign like an invoice + invoice items...

so

InvoiceComponent
Invoice : InvoiceComponent (inherits).
InvoiceItem has a foreign key into Invoice...and fk into InvoiceComponent..

So you can create composite invoices of invoice Items and invoices...

Delete an item and....


"A relationship is being added or deleted from an
AssociationSet 'FK_InvoiceItems_Invoice'. With cardinality constraints, a
corresponding 'InvoiceItems' must also be added or deleted

!

but I'm not trying to delete an invoice, I'm trying to delete and
InvoiceItem, that I've referenced through the relationship from the
Invoice.

Any ideas?

===================================
This list is hosted by DevelopMentor®  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com