Randomblink
The Irreverent Reverend
- Local time
- Yesterday, 18:45
- Joined
- Jul 23, 2001
- Messages
- 279
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!
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!