I have a stored procedure that looks up a record in a lookup table to find the last student id used, adds 1 to it, saves the record into this lookup table, then a new record is added to another table using this new student id.
This works fine, however I have another stored procedure to lookup values in a table to use as defaults, these are set by the user and can be different depending on which year the user chooses, hence why I cannot have the defaults set within the table.
When this stored procedure is ran it shows results as an access crosstab query would, there will only ever be one row in the result, question... how can I use the result of this stored procedure to update the student record I have just added to the table?
Thanks in anticipation...
This works fine, however I have another stored procedure to lookup values in a table to use as defaults, these are set by the user and can be different depending on which year the user chooses, hence why I cannot have the defaults set within the table.
When this stored procedure is ran it shows results as an access crosstab query would, there will only ever be one row in the result, question... how can I use the result of this stored procedure to update the student record I have just added to the table?
Thanks in anticipation...