Z
Zelgrath
I have 3 fields named JobId(integer), StationId(text), and
Year(integer). I also have a field, Occurance(integer),
which tracks how many duplicates have occured. I want to
make a procedure which concatenates the values in the
form "JobID-StationID-Year-Occurance" to generate a
primary key.
Where would I put code to do this? How would I check if
the first 3 values exist and increment occurance to a
suitible value.
Year(integer). I also have a field, Occurance(integer),
which tracks how many duplicates have occured. I want to
make a procedure which concatenates the values in the
form "JobID-StationID-Year-Occurance" to generate a
primary key.
Where would I put code to do this? How would I check if
the first 3 values exist and increment occurance to a
suitible value.