Access help

  sebina12 12:06 11 Jul 06
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 06

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.

What is ransomware and how do I protect my PC from WannaCry?

What I learned from my mentor, Oscar-winning VFX supervisor Phil Tippett

Siri vs Google Assistant