microsoft access courses - Primary Key

Hi Dan

To do this you would need to have all the details submitted to a form before they went anywhere the actual database. You would then need to write some code to get the letters that you need and join them. then submit to a database.

I would also say that the primary key has to be unique, so what would happen if two people had the same name?

I suggest you give you primary key a little more thought and make sure that there is no way that a duplicate will exist.

Hope this helps

David