How to set time field in Access so that it stays fixed

S

Sharon

I am using the date and time formats to give me unique numbers which will be
associated with a project name and have managed to insert the expressions for
this individually but I need these fields to retain the numbers and not
change as time and date moves on. Is this possible? Can anyone help?
 
R

Rodger

Sharon,

What you want to do is have the PROJECT table with an ID typically set to
autonumber and then any table that needs to link to the PROJECT table you
have that PROJECT ID in the other tables.

Does that help?

Rodger
 
Top