P
p-rat
I have a system that has three tables Header, Payroll, Invoice. The
main data entry form can also be opened in Edit mode for changes. This
form is a 'ticket'. Our 'jobs' can be made up of 20-100 tickets. We
want to now be able to push this data into another system through an
import/export process; one job at a time. Once we verify the
information is good and we export, I want this process to push a
timestamp into a column in my Header table 'closed_date'.
So, I think I will need an update query to search for ALL the tickets
that are involved in the Job to be exported and then place the
timestamp in the 'closed_date' column. I also want, though, to LOCK
all the records that make up the tickets on the job from further
editing. How is this done.
The main entry form has to continuous sub-forms on it. Will I have to
place some code in each form or will placing code in the main form
work?
Not sure what the code will be, but am trying to guidance to see if
I'm going down the right path or not. Also what even would I place the
code in? Thanks for any help anyone can provide.
main data entry form can also be opened in Edit mode for changes. This
form is a 'ticket'. Our 'jobs' can be made up of 20-100 tickets. We
want to now be able to push this data into another system through an
import/export process; one job at a time. Once we verify the
information is good and we export, I want this process to push a
timestamp into a column in my Header table 'closed_date'.
So, I think I will need an update query to search for ALL the tickets
that are involved in the Job to be exported and then place the
timestamp in the 'closed_date' column. I also want, though, to LOCK
all the records that make up the tickets on the job from further
editing. How is this done.
The main entry form has to continuous sub-forms on it. Will I have to
place some code in each form or will placing code in the main form
work?
Not sure what the code will be, but am trying to guidance to see if
I'm going down the right path or not. Also what even would I place the
code in? Thanks for any help anyone can provide.