I am using the After Record Added Event and trying to add a record within a table called Task the following information:
dal.tblTask.Task_Type="Contract"
dal.tblTask.Start_Date=Now()
dal.tblTask.End_Date=Now()+50
dal.tblTask.File_Id=Show_key1
dal.tblTask.Add()
This is to be generic informaton and only the File_id field will link the main table to the Task table. When a user creates a new record in the main table I plan to sporn a number of new records in the Task table associated with the Main Table record. There is no field in the Main table (apart from the File_Id) that is also in the Task table. This is fundamentally a project - task tracking solution. A project sporns a number of tasks.
I am currently testing with just one record called Contract in the Task table. When I add a record it works but I can't seem to be able to associuate it with the original Main record. The File_Id is tyhe field that should hold the Main table record association. How do I code this link?
Regards
Jeremyb