Field Relationships and Auto-enter
I want to create a field in a database for a contact ID number. The database is a list of transactions, and I want the ID number to correspond to the email address. For example, every time I enter a transaction by email@example.com, the ID number associated with that email address is entered in the contact ID field, but if I haven't entered his email address before, he is assigned a new ID. Is there a way to do this automatically?