hi Folks,
can anyone help on this one?
I have a typical one to many relationship but my client wants to create a table from these separate records merged into one record.
e.g. Primary key in master record plus an unlimited number of foreign keys from the many relationship, then to create one...