Hi there
I have a 1 to Many relationship between 2 tables where the primary key is a combination of the surname and address. So there is multiple people (parents, children etc) at the same address in my detail table.
person1 129kensingtonst
person2 129kensingtonst
person1 30clasibrookrd
person2 30clasibrookrd
I need to be able to output to a new table (for exporting purposes) where it merges all the information into a single record. ie.
surname address person1 person2 person3
What is the best way to do this?
I have a 1 to Many relationship between 2 tables where the primary key is a combination of the surname and address. So there is multiple people (parents, children etc) at the same address in my detail table.
person1 129kensingtonst
person2 129kensingtonst
person1 30clasibrookrd
person2 30clasibrookrd
I need to be able to output to a new table (for exporting purposes) where it merges all the information into a single record. ie.
surname address person1 person2 person3
What is the best way to do this?