Did you check for answers you received yesterday?
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Burghew" <burghew@mailinator.com> wrote in message
news:cpgf63$1108@news-dxb.emirates.net.ae...[color=blue]
>
> I have 2 fields called document & Revision which contains the titles for
> the documents to be stored in the databse it gets filled up as the user
> enters them and the revison numbers associated with them.
> 1. What I need to do is to make sure that no duplicate entry is entered
> for
> document and if entered should have a different revison number. I cannot
> make them both as the primary key bacause there may be times when both the
> fields maybe null but the entry must be there in the database.
> 2. If the user types in an existing document then I need the revision
> field
> to be filled up with the current revision number after update.[/color]
