Create Records

[James Tebb]

I have a table that logs events. The fields in this table include:-
Event Name
Start Date
End Date

I have a second table that logs the schedule for each day of the event. This has the following fields:-
Event Name
Date
Event Detail

The tables are linked via the event name (this all works fine).

When I enter a new event in table one I want the second table to create records for each day of the event starting from the day before the start date and ending on the end date.

Any ideas??

 

[Erick]

One way that I can think of achieving this is to put Table1 into a form (you can make it a datasheet form to make it look like a normal table). From here you can create a an 'AfterUpdate' code that will look up if the relevant target 'Event' in Table1 doesn't exist in Table2 then Append new date records in Table2.

I think the only way to achieve what you want is via vba code and I don't think there is a way of triggering a vba code after updating a table directly, hence the suggestion of creating a form to trigger the vba code....hopefully that makes sense.