B
Bob Mullen
I am working to develop a scheduling system in which I want to create a
custom set of scheduled block times of varying lengths etc from a form. I
have a prototype working for a single table that is not Normalized (ie:
Date, Description and Format fields are repeated for each record produced).
I would like to Normalize the table by creating one primary table for Date,
Description and Format and a schedule table that is related by the DateID
from the primary. Creating the tables and relationships is not a problem. I
am having trouble writing the code to write a single record to the primary
table and then a series of related records to the schedule table. Must it be
done as two steps (using 2 different recordsets and separate addnew code
blocks? How should I then write the DateID from the primary table to the
related (one to many) table.
Would I be better off leaving the table alone as it is (not normalized)?
custom set of scheduled block times of varying lengths etc from a form. I
have a prototype working for a single table that is not Normalized (ie:
Date, Description and Format fields are repeated for each record produced).
I would like to Normalize the table by creating one primary table for Date,
Description and Format and a schedule table that is related by the DateID
from the primary. Creating the tables and relationships is not a problem. I
am having trouble writing the code to write a single record to the primary
table and then a series of related records to the schedule table. Must it be
done as two steps (using 2 different recordsets and separate addnew code
blocks? How should I then write the DateID from the primary table to the
related (one to many) table.
Would I be better off leaving the table alone as it is (not normalized)?