J
Jon
Greeting,
I have the following query which makes a sequence number for group of record
for each Plant:
SELECT a.PlantID, a.ID, Count(*) AS SQ
FROM SPtbl AS a INNER JOIN SPtbl AS b ON a.PlantID = b.PlantID
GROUP BY a.PlantID, a.ID;
What I want to do is how to update this value into a table once a new record
is added. In other word, once the user input a new record, the form record
shows only the plant record with sequence
I have the following query which makes a sequence number for group of record
for each Plant:
SELECT a.PlantID, a.ID, Count(*) AS SQ
FROM SPtbl AS a INNER JOIN SPtbl AS b ON a.PlantID = b.PlantID
GROUP BY a.PlantID, a.ID;
What I want to do is how to update this value into a table once a new record
is added. In other word, once the user input a new record, the form record
shows only the plant record with sequence