I run a supply database and order from multiple companies. My users have the opportunity to use the database to request supplies. I have different tables/forms for each vendor describing what they offer. These tables/forms are linked together through an OrderRequest table which tracks order numbers. I would like to have different Order Numbers for each type of company. For example if an order is placed using CompanyA Form I would like the UserNumber (autonumber) to display something like A001, and if an order is placed using CompanyB Form the autonumber in OrderRequest table to display B002. I want these text prefixes to be embedded in the table so that I can reference them with queries. Anyone got any ideas?