Search results

Any Ideas?

Even with the primary key defined, I still get the same message. Thanks again for your help.

I am trying to update a field (CustID)in a table (customers). There are no primary keys defined. I have a lookup table called lookup, which contains two fields, group and prefix. The prefix is the first letter of customers lastname in the table customers. The group is a number code for the...

Thanks for your help Chris, but how would I write a code for the prexix, since I am new to access. Thanks again Chris. [This message has been edited by BoxRH (edited 10-25-2001).]

I am working on a database for a small law firm. I want to create a unique identifier field from clients surnames. I want the field to start from 1000 if the surnames begin with A, B, and C and from 2000 if they begin with D, E, and F and so on. can that be done?