Hi Mark,
Thanks for replying. I had thought of using reports as the control, but there is a unique ID required so the record in the table will need to be reflected as a new entry with the same ID needing to be used for the newly entered record; while still maintaining the previous record. This info also connects to relationships in 2 other tables that will also need to pull that info over as well.
I've tried various ways to think it through a pipeline but can't configure a solution.
------------------------------
Lorrie B
------------------------------