Question for Access?

  jonargent 18:12 20 Sep 2008


I've just started to use Access, and was wondering if there is a way to set the ID number to recur through out its tables? At the moment, I have about 15 tables in one database, but all set indivual IDs per table...

Hope that makes sense?


  Belatucadrus 18:33 20 Sep 2008

Welcome to the wonderful world of relational databases and the importance of designing it before trying to make it, as backtracking is frequently a pain in the but if possible.
A couple of links that may provide some useful reading :-
click here
click here
click here
click here

  Woolwell 20:33 20 Sep 2008

Each table will set individual ID's. Why do you want them to be the same? If you want to relate a unique number to each table then you probably need to set up another table and set up a relationship.

  silverous 22:49 20 Sep 2008

Something like this discussion may help:

click here

The basical principle being to have a separate table to store your custom autonumber, then put some code on each form so that it gets the maximum number from the control table and updates it each time you add a record.

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

Elsewhere on IDG sites

iMac Pro review

Illustrator of witty, relatable Instagram comics Julia Bernhard touches on our humble moments

iMac Pro review

Quelle est la meilleure application de podcast pour Android (2018) ?