B
Brad_A
I am trying to write a program that does the following...
Asks user to process all temp records (this is already set using a yes/no
box)...
If yes,
Takes tblCarMaint and changes the field Process from "n" to "*"
It exits and goes back to the mainSwitchboard screen
If no,
It sets them all to "*" and prompts user to make changes manually (there may
be a couple that need to be held)... there is a Process field that can be set
to the following:
* = processed
n = not processed
h = hold
======================================
Seperate Program
When a new Train is added, I need for it to check each CarNo on that
train... a CarNo can be on many trains and many CarNos are on one train...
what I need it to do is to take Curmile (current miles) on TblCar and add the
trip distance to each car on a train... I will set up a process field like
above that will note whether or not the process has already been performed
....It will calculate by parsing the last 5 digits of the field Train in the
tblTrain, doing a lookup in a tblMine for field Mileage and adding that
number to CurMil on tblCar.
Asks user to process all temp records (this is already set using a yes/no
box)...
If yes,
Takes tblCarMaint and changes the field Process from "n" to "*"
It exits and goes back to the mainSwitchboard screen
If no,
It sets them all to "*" and prompts user to make changes manually (there may
be a couple that need to be held)... there is a Process field that can be set
to the following:
* = processed
n = not processed
h = hold
======================================
Seperate Program
When a new Train is added, I need for it to check each CarNo on that
train... a CarNo can be on many trains and many CarNos are on one train...
what I need it to do is to take Curmile (current miles) on TblCar and add the
trip distance to each car on a train... I will set up a process field like
above that will note whether or not the process has already been performed
....It will calculate by parsing the last 5 digits of the field Train in the
tblTrain, doing a lookup in a tblMine for field Mileage and adding that
number to CurMil on tblCar.