I have a 10 digit predetermined ID number.
What I want to do is when a new number (the number referred to above) is added to the database, information based on this number will appear.
The producer is based on the first three digits, the owner is based on the first three and the last two, and so on.
How do I do this????