I have been working on an import for a client to work order to enter time.

The data I have has the work order number,  the time,  employee,  and the step number always default to 10.

However, the entry requires the WORK_CENTER and the OP_CODE which would already be specified in the work order.   Unfortunately the file assign feature doesn't have a link to look up the work center and op code based on the work order number and step.  

Seems a bit odd to me that you could do that.

I've been working on some perform logic to do that but it has been a little while since I have worked with perform logic and I really never did that much to begin with.

Am I just overlooking something simple?  

-------

Suddenly had the thought of taking the client's import data file in excel and putting in a dump of the work order detail line files and doing a lookup there so that the data fed to the import would have it pre-looked up.