Hi,
i run access system for our invoicing. i have 2 tables
1. invoices
2. Collection
for each row (invoice) in table 1 there might be multiple rows (collection) in table 2.
to show the pending collection i have to create 1 query for table 2 (Collection) with sum of the amount column, then link it to a 2nd query sothat it will total the collection for each single invoice and i can show only the uncollected invoices/partialy collected invoices.
my problem is that in the query showing the pending coleltion i cannot update any data "The record set is not updatable", any one have solution?
i run access system for our invoicing. i have 2 tables
1. invoices
2. Collection
for each row (invoice) in table 1 there might be multiple rows (collection) in table 2.
to show the pending collection i have to create 1 query for table 2 (Collection) with sum of the amount column, then link it to a 2nd query sothat it will total the collection for each single invoice and i can show only the uncollected invoices/partialy collected invoices.
my problem is that in the query showing the pending coleltion i cannot update any data "The record set is not updatable", any one have solution?