I have two duplicate tables, they contain dates. One table is for the PLANNED dates (ie planned to do X on entered date) and the other for ACTUAL date (ie actually did X on entered date.

I have a relationship with these two tables to a master table containing Project information. The related field is called [PROJKEY] which is a number field in the two duplicate tables, and an AUTONUMBER in the master table.

What I want to do, is:

Whenever a new project is entered into the master table, and a [PROJKEY] is generated in that table. I want to start a record in both the duplicate tables that contains ONLY the new [PROJKEY].

This way, whenever I enter a new project, there is data in the duplicate tables that I can reference through a query, even if the only data is a new [PROJKEY] and whatever defaults I have setup for each field.

How do I create these records? Through an append query that is activated once the [PROJKEY] field is GotFocus/OnChange'd? Or is there another route that might work better?

HELP!

Why can't you have planned and actual dates in the same table?

The reason I "couldn't" (or so I thought) was that the dates entries had the same names and I didnt want to flood ONE table with 50 or so entries that were duplicated based on PLANNED or ACTUAL.

As it turns out, I have done just that. I took each field and ended the fieldname with either PLA (for planned) or ACT (for actual) thereby removing the need for whatever I was asking.

Thanks anyway!