Question Search and then Populate

[Docara]

Hi
I'm working on a system where I have produced a unique order number (concatinated from other fields) which is to be given to a wholesaler when an engineer is on the road and has to purchase goods 'on account'.

How do I now use this number in reverse to to populate a report with all the relevant values.

Background :- I am referencing the following tables and using a date/day value

tblClient (via tblSite)
tblSite
tblEngineer
tblJob

I'm guessing that I have to use known fixed string lengths then split them off into the relevant sub strings but is it then possible to plug these values into a query?

Any suggestions wouls be appreciated
Thanks
Matt

 

[Steve C]

Yes it's straightforward

What are the field lengths of the original fields?

I'll have a go at answering this one.

 

[DavidAtWork]

As a start, just post an example of a concatenated unique order number and exactly which parts you are trying to extract. You will need to specify the expected length of each part and the data type too.
David