Somehow I volunteered to build a contact list and integrated production order database for my company...wise idea...
I've managed to build and integrate almost everything, from existing templates included with FMP 6, but have one problem.
In the contact database, I have two fields that I would like to work together. When someone enters a company name for a contact, I would like that company name if not yet entered into the database to recieve a customer number in the form of a 3 digit serial #, such as 001, 002, 003, and so on. But for instance if a contact is entered, and the company has already been entered for a previous contact, I would like that company's corresponding customer number to be automatically entered.
I've played with making a field use serial numbers, but as you can see, I don't need a new serial number for each new contact, only for new company field within the contacts.
Anyone?
I've managed to build and integrate almost everything, from existing templates included with FMP 6, but have one problem.
In the contact database, I have two fields that I would like to work together. When someone enters a company name for a contact, I would like that company name if not yet entered into the database to recieve a customer number in the form of a 3 digit serial #, such as 001, 002, 003, and so on. But for instance if a contact is entered, and the company has already been entered for a previous contact, I would like that company's corresponding customer number to be automatically entered.
I've played with making a field use serial numbers, but as you can see, I don't need a new serial number for each new contact, only for new company field within the contacts.
Anyone?