I'm designing a form based on a database of client callins. Whenever a client calls in, a new record is added to the database. There is a field (Client ID#) that up to this point has been manually entered. I cannot use autonumber for this field as one client may very well call in more than once. What i would like is that when a new client calls in, the form would search the database for the highest ID#, then increment it by one and prepopulate the client ID field. I realize that this is not the best way to set up the database but my customer had already set it up this way and does not want it changed.
Thanks.
Thanks.
