I have a database (MS Access 2003), until recently I had 1 table with pupil names and addresses which I merged with MS Word 2003 and all worked fine. I have now had to split the table as pupils can have more than one Parent at different addresses. So, I have a 1-many relationship between pupil and address table.
I have created a query to bring all the data together but now when I try and merge it I only get 1 record rather than 180 as there should be.
I have searched loads of web sites tried all sorts of connotations of queries and word docs. Any suggestions appreciated.