Good day,
I think I have the title right on my post. I have attached my db so my I am explaining maybe easier to understand. If you open the db and click Find and enter "Simpson", next click Select. For the "Schedule / Attendance" section I have created a table that will capture the 8 textboxes plus the SO ID of person, in this example Homer. But my problem is, say on May 18th he completes the Core 1 section, but don't complete the Core 2 until May 20th. I only want one record in the tblsch_att for Homer, but I don't know how I can search the table and find the entry from the 18th and Added the 20th to the corresponding record in the table. Furthermore, the only want I can get a record added to the tblsch_att table, is that I have to fill in all textboxes, but I intended to only to have Core1 done one day, Core2 the next day and so on.
Make sense!
Any help on what function can complete this would be great.
________
honda gold wing history
I think I have the title right on my post. I have attached my db so my I am explaining maybe easier to understand. If you open the db and click Find and enter "Simpson", next click Select. For the "Schedule / Attendance" section I have created a table that will capture the 8 textboxes plus the SO ID of person, in this example Homer. But my problem is, say on May 18th he completes the Core 1 section, but don't complete the Core 2 until May 20th. I only want one record in the tblsch_att for Homer, but I don't know how I can search the table and find the entry from the 18th and Added the 20th to the corresponding record in the table. Furthermore, the only want I can get a record added to the tblsch_att table, is that I have to fill in all textboxes, but I intended to only to have Core1 done one day, Core2 the next day and so on.
Make sense!
Any help on what function can complete this would be great.
________
honda gold wing history
Last edited: