Add Record Tables with No permanent data?

  • Thread starter Thread starter Jason O
  • Start date Start date
J

Jason O

Hi,

I wondered if anyone could clarify something for me. I have inherited the
responsibility for a few databases at work as the previous member of staff
left the company. However, they contain a type of table I am not that clear
about.

For each main table there is an 'add' table. For example, for the main
"Contacts" yable for example, there is an AddContact table. These Add
tables, when opened do not contain any data (other than a =Now() Date
field), but are the basis for the forms in which data is added to the main
table.

Can anyone tell me what what this type of table is called? I can sort of see
what it does but have no idea as to how it was done. If I wanted to do this
myself how would I go about it?

Any advice is greatly appreciated.

Many TIA,

Regards

Jason
___
 
This is a guess as to the function of the table. In adding new records the
ADD table might be part of query used as record source for the data entry
form.

Does the Contacts table have a field that has the datetime the records was
created? If so then just using a default on the field of Now() might do it.

Use the TOOLS - Analyze - Documentor to find what queries, forms, or reports
that use the ADD table and reverse engineer.
 
Another hint that the above is the use for the table, is if there is a
"Save" button on the form that is used to add a new contact. If there
is, check to see what code there is in the onclick event.
Our guess is that it will run a macro or a series of queries that will
append the "new" record from the addcontact table to the real contact
table. (and then perhaps one to empty the add contact table.
 
Back
Top