That makes sense, thanks man.

I'll add another table to accommodate! I didn't think of that.

I really appreciate your post.

But then how would I be able to reference all of the records in the Interest table that are a part of the composite?

Identity,Vendor, Offer

1001,380,1

1002,380,2

1003,380,3

1004,380,4

NoteID, VendorID, Description

1,380,Description

2,380,Description

3,380,Description

I need all...

Ok, Thanks for the advice, I didn't know if there was some kind of SQL standards out or some kind of best practices that could be used.

I'll definitely take your...

Thanks for the response on this it was helpful. I will probably use a method to capture the values and put them in another dataset that would have the...

Thank you so much for your help with this!!!

I will also take a look at XQuery as an option as well.

😎