Hi I was wondering if it is possible to create an additional key field. If yes, how is it done?

Reena

Why?

If you have one key field, it will keep the records unique.

What is your goal? Why do you want to create another "key field"???

Regards,

Eliot Lee

My database is used for the Lab INventory. I have 5 fields. The key field is the Item #. The Item # is given to the item as it is added to the database. I also have another field for the serial number. I want the Item # field, but at the same time I would like the serial # field to be unique to avoid having the same item entered twice and I also want the item # field to be unique. Do you have any idea how I might be able to make another key field?

Reena

Checking duplicates across multiple fields has been discussed before in the forums and I believe you can find codes for checking duplicates at the Unofficial DBMAN FAQ web site, which is linked in the Resources.

Creating another "key field" would be more effort than it's worth.

Regards,

Eliot Lee

Hi Eliot-

I found a the answer to my question on the DBMan WebMagic site. Here's the link to the page in the case someone else has the same question http://webmagic.hypermart.net/dbman/field47.txt

Thanks for your help!

Reena

You're welcome.

Regards,

Eliot Lee