L
Lauren Quantrell
I'm trying to extract a list of UniqueIDs from each row in a list of
records that populates a form. I populated this form with the results
of a stored procedure (Forms!myForm.RecordSource = myStoredProcedure).
myStoredProcedure only returns two fields: UniqueID and EmployeeName
from the table tblEmployees.
This form is populated from numerous possible stored procedures
myStoredProcedure(x).
What I need to do is to create a report with the list of Employees
returned by myStoredProcedure(x) but with all the fields in
tblEmployees.
I'm thinking: extract the UniqueIDs from the form, populate
tblEmployeesTEMP, join that tblEmployeesTEMP to tblEmployees and use
that as the recordsource for the report?
Is this viable or am I missing something obvious? (there could be well
over 10K records in this report)
Any help is appreciated!
lq
records that populates a form. I populated this form with the results
of a stored procedure (Forms!myForm.RecordSource = myStoredProcedure).
myStoredProcedure only returns two fields: UniqueID and EmployeeName
from the table tblEmployees.
This form is populated from numerous possible stored procedures
myStoredProcedure(x).
What I need to do is to create a report with the list of Employees
returned by myStoredProcedure(x) but with all the fields in
tblEmployees.
I'm thinking: extract the UniqueIDs from the form, populate
tblEmployeesTEMP, join that tblEmployeesTEMP to tblEmployees and use
that as the recordsource for the report?
Is this viable or am I missing something obvious? (there could be well
over 10K records in this report)
Any help is appreciated!
lq