Copy records

[RitaMoloney]

Hi,

I need to copy a record in the table tblAccDetails to all other records in the same table that equals the same Collection Type in table tblCollections. (The user will enter the first record in tblAccDetails)

tblAccDetails
AccDetailsID
YearID
CollectionID (FK)
CollectionDate
Status
Description
AmountPaid

tblCollections
CollectionID (PK)
YearID
CollectionType
NoCollections
AmtPerCollection

Please could someone help me out with this.

Thanks in advance,

 

[aleb]

Do you need to append a record to all other record with the same collection type or you need to update the records with the same collection type ?

Is it not so that details make a unique record and updating the records with the same data violates some normalization rules ?

May be there is something wrong with dbase structure/logic ?