Question Which shipping company issued a tracking number? (1 Viewer)

[bulrush]

A2003 on WinXP

Hi,
We order packages from many vendors and they each use one of three shipping carriers: UPS, USPS (US Postal Service) or Fedex. I have a field in my table which stores the tracking number we are given from the vendor.

I have a label on my form which I want to turn into a clickable link based on the tracking number. But I have to determine, from the tracking number only, which shipper issued the tracking number. Is this possible? Or does the user have to manually choose (and I store on the table) which company issued the tracking number?

Thank you.

 

[spikepl]

as far as i remember, Fedex and UPS have a differnet number of digits and composition. USPS I do not know - have a look at the AWB's you already have in your possession, or check on their respective tracking sites for examples.