Cable Forum - View Single Post

Indians · 04-08-2004, 20:07

....for the date, set the field type to date/time then set the default value to =Now()

Also I would put the 'Issue' info in a seperate table linked to the main 'Drawing' table with the Drawing Number as the Primary key (link) you can then put the issue info in as a subform and have all the issue history together, assuming a drawing may be issued several times at different revisions.

04-08-2004, 20:07	#9
Indians Inactive Join Date: Nov 2003 Location: Grimsby Posts: 199	Re: MS Access Guru sought? ....for the date, set the field type to date/time then set the default value to =Now() Also I would put the 'Issue' info in a seperate table linked to the main 'Drawing' table with the Drawing Number as the Primary key (link) you can then put the issue info in as a subform and have all the issue history together, assuming a drawing may be issued several times at different revisions.