Access help

  sebina12 12:06 11 Jul 2006
Locked

Hi, I am wondering how you could add your own product ID/Code field to Microsoft Access's 'Order Entry' template? I am quite new to Access and there is plenty I still don't know about it, so maybe someone could tell me step-by-step. I am starting my own business and would like to put in my own product ID/Codes. I would appreciate any help here at all. Many thanks!

  Harpur 12:46 11 Jul 2006

hi there i had a look at the template and it could be difficult to add fields to these. it would take a lot of moving and redesigning of the template. it can be done but if you are unsure it maybe better to create your own. also to create the field you will need to have access to the table on which the template is based. if you designed your own, then you can then put in your id field as a primary key (this gives each product a unique number which cannot be re-assigned to another product). this will allow for easier queries and reports later.

if you want anymore help you can mail me.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

The secrets of creating gory VFX

How to update iOS on iPhone or iPad

WhatsApp : comment lire vos messages sans que l’expéditeur le sache