You are here:
You still are making this clear. what you are saying doesn't sound logical. If you are saying that the Register Date may be the same as the Actual Date and when it us you don't want to key in the same
First, your database is not normalized properly. By having fields for each division number you have created a repeating group which violates normalization rules. You should have 2 tables here. One
Access 2007 has two modes for displaying documents (forms, reports, queries, etc.); Tabbed documents or Overlapping Windows. These modes are set using the Office button, selecting Current Database and
Very good. You referred to a document number, so I assumed it was a number datatype. I still think the second method I suggested will be easier for the users. Hope this helps, Scott<> Microsoft
I suggest you read up on Normalization. Customer name should exist in ONE table and ONE table only, the Customer table. The customer table should have a primary key (not name) that would be used as a Foreign

©2009 About.com, a part of The New York Times Company. All rights reserved.