Update multiple record values in form/query

T

Todd H

I am not sure where to start with this issue. I have a simple budget/
cost tracking data base that has three tables; tblTracking,
tblLineItems, and tblPayments.

tblTracking has the following fields: RecordNo(key), Title, and
Approved(Y/N)
tblLineItems has LIID(hidden key), RecordNo, CostCode, Amount
tblPayments has PMTID(hidden key), CostCode, Amount, BillingPeriod
 
T

Todd H

I am not sure where to start with this issue.  I have a simple budget/
cost tracking data base that has three tables; tblTracking,
tblLineItems, and tblPayments.

tblTracking has the following fields: RecordNo(key), Title, and
Approved(Y/N)
tblLineItems has LIID(hidden key), RecordNo, CostCode, Amount
tblPayments has  PMTID(hidden key), CostCode, Amount, BillingPeriod
Click to expand...

Sorry for the multiple posts...I have started a new post with more
refined info.
 
T

Todd H

I am not sure where to start with this issue.  I have a simple budget/
cost tracking data base that has three tables; tblTracking,
tblLineItems, and tblPayments.

tblTracking has the following fields: RecordNo(key), Title, and
Approved(Y/N)
tblLineItems has LIID(hidden key), RecordNo, CostCode, Amount
tblPayments has  PMTID(hidden key), CostCode, Amount, BillingPeriod
Click to expand...

Sorry for the multiple posts...I have started a new post with more
refined info.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update multiple record values in form/query 0
Update multiple record values from form/query 0
Update multiple record values 1
Update multiple record values from form/query 1
Update Y/N check box for all like records 2
SQL Query Double Counts on Multi-Table Query 3
delete query that deletes data in multiple tables 3
eliminating duplicate records in select query 1

Top