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 record.
i.e. PK,fk,fk,fk,fk ........etc.
I thought I'd solved it witha crosstab query but unfortunately this limits the number of columns (fks) to 256.
Any ideas?
many thanks
Peter

That shouldn't be a problem as Access does not allow more than 256 fields in a table.

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 record.
i.e. PK,fk,fk,fk,fk ........etc.
Why? I ask this not to be awkward but you're asking us to solve a solution that doesn't work rather than giving us the original problem.