I need some help in setting up the tables in my database. I have a dataset of 'Assemblies' and a dataset of 'Parts' which make up the Assemblies. My confusion comes from the fact that a given part can be linked to multiple assemblies. So, the problem is no longer one to many... it's more many to many.

Is there a simple solution to this problem?

Thanks!