Import from a Staging Module to a numbered list
I am struggling with the following:
I have a staging module, dimensioned by Users, where individual users can input some data (CostCode, Currency, Cost Type, Forecast Reference), and once completed, I want to run a process to create a new item in a numbered list (that holds the full set of approved transactions) and then import from the staging module to an "information" module, which is dimensioned by the numbered list.
The slight issue is that no combination of the input properties can be used to create a unique reference, as duplicates are permitted, but of course the numbered list requires a unique reference.
Does anyone have any advice/alternative suggestions about how to approach this problem?
Apologies if I haven't provided much information, I'm still fairly new to model building!