JimS-Indy (12/5/2012)
This is a list of Part numbers (Items) linked with their (zero or more) Sources of supply (vendors, etc.) An item could have half a dozen sources, though typically zero or one.I'll post the code when I'm done, but I've got it doing almost everything now in 7 seconds, using GUIDs.
That's definitely a many-to-many requirement! 🙂
When you say "everything now in 7 seconds", what does the "everything now" mean and how many rows are you talking about?
--Jeff Moden
Change is inevitable... Change for the better is not.