edit fields to change multiple rows of data

  • Thread starter Thread starter p-rat
  • Start date Start date
P

p-rat

I have a database where people enter in Field Tickets. There might be
multiple field tickets for one job. We have a Job Number field that we
use for this. Anyhow before invoicing there may be changes that need
to be reflected in this data. Rather than have the end-user go back to
10 individual tickets and open them up to make changes, I'd like to
have the capability of the user to make one change in a field and then
the same fields change in the multiple rows.

I would like to have a pop-up form or something that asks the user for
'Job Number'. This in turn will bring the necessary information in
multiple rows. How can I have it to where the end-user selects one
field to revise, makes the change, and all the same fields in the
multiple rows get changed also?

any help would be greatly appreciated. thanks.
 
I have a database where people enter in Field Tickets. There might be
multiple field tickets for one job. We have a Job Number field that we
use for this. Anyhow before invoicing there may be changes that need
to be reflected in this data. Rather than have the end-user go back to
10 individual tickets and open them up to make changes, I'd like to
have the capability of the user to make one change in a field and then
the same fields change in the multiple rows.

I would like to have a pop-up form or something that asks the user for
'Job Number'. This in turn will bring the necessary information in
multiple rows. How can I have it to where the end-user selects one
field to revise, makes the change, and all the same fields in the
multiple rows get changed also?

any help would be greatly appreciated. thanks.
Click to expand...

Does this fact apply to ALL field tickets related to an individual
job, or only some of them? (This is an "all or nothing" question.)
If it is, then this fact belongs in the Jobs table, not in the Tickets
table. Otherwise, you would have to be able to specify which records
to update... or do it manually with a combobox in your subform (based
on Tasks)
 
This applies to all Tickets in a Job. A little more detail is that we
sometimes don't know if the Tickets and Invoiced Items in the invoice
sub-form are 'taxable' or 'non-taxable'. If one ticket of the Job is
taxable; then all Tickets are taxable. I would like to bring all the
ticket information (basically just the invoice line items with the Tax
Schedule, Tax Class, and Tax Rate fields) in from a query or something
and change one row, then subsequently this changes all other rows to
the same edited values. I don't know how to do this or how to proceed.
Thanks for your reply.
 
Back
Top