RitaMoloney
Registered User.
- Local time
- Today, 02:44
- Joined
- May 6, 2004
- Messages
- 50
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,
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,