Validation sets
I have a custom table XYZ that stores a value in one of the columns that is called File_Name. The column's data is always loaded in the format of
CustomerNumber_FileName i.e. (1234_Tap15032010.csv). A second column in the same table stores the data of customer_number. The data is loaded into this table via a custom process that a user will submit via a request set.
So to set the scene the custom table if it only stored 2 columns would look something like:
File_Name Customer_Number
-------------------------------------------------------------------
1234_Tap15032010.csv 1234
After the data file has been uploaded into the custom table XYZ the users would do a sub-sequent process that runs through this table and does a matching of each remittance to an invoice number. Now what the process does is not really important. What I want to do is to set up a validation set or some method that will pop up the correct customer_number in the parameters.