HELP with an append in Access!!!!

[Rjconrep]

I have two table in Access that are relational based on the customer account number. I need the information that is in the Header table to be appended to the end of the records in the Detail table.

I need it to look like this
Record 1 in table Detail
Fname lname company account# address

Record 1 in table Header
account# Description1 Description2 Description3

I need a new table that will look like this
Fname Lname Company Account# Address Detail1 Detail2 Detail3

One individual from the Detail table may have up to 50 different Descriptions. I need one record to display them all (not one field).

 

[Ecniv]

Record 1 in table Detail
PersonID
Fname
Lname
company
Address1
Address2
Address3
Address4
PostZipCode

Record 1 in table Header
PersonID
AccountNo
Description

I need a new table that will look like this
Fname
Lname
Company
Address1
Address2
Address3
Address4
PostZipCode
Account
Detail

Probably need to use a crosstab if the account descriptions vary. This is a more relational set up for the tables. Not sure whether this helps you though in the set up.

Vince