Can I pass New IDs from one Multiple Insert to another?

In short, here is what I am trying to do.

I have a Multiple Insert behavior (5 iterations). Working great.
I then need a second Multiple Insert behavior that inserts into a second relational table, using the newly created id for each.

This is something I do all the time using the Single Insert behavior. The SESSION ID is easy to use. But the Multiple Insert behavior doesn't seem to create any session array that I could use.

Am I overlooking something or is this not possible? I tried going with the Manage Relational Table but hit a road block when it asks for the Main key value.

Thanks,
TroyD

No, the multiple insert behavior does not save the inserted IDs to a session.

That's what I was afraid of.
Is there a way that I could post them to a second results page and go from there?

In other words, they are inserted as new, but then immediately appear on a second page in a result list containing only those new records?

I've thought about maybe trying to query the highest table id number right before the first insert, then query them on the second page based on that data. But I wanted to check on a cleaner method. There is a chance for error doing it this way because of the off chance that more than one person is inserting records at the exact same time. Thoughts?

Thanks
TroyD

i think the only way that could be done is to have a new column that gets a 0 value on initial insert. on the next page, you can return the records with a 0 value for that column, then update that column to 1.

Very good idea Jason. Thanks so much.

I'm going to take your idea and tweak it a little by tagging one of the current columns. I love creative ideas.

Thanks Again,

TroyD

I'm always afraid to throw out ideas like that. In the past I have made similar suggestions and the person asking the question had no idea how that would work...