K
Kevin
Ok, a little more info on my previous post. What I am
attempting to put together is a Truck Delivery Schedule,
in which I have 8 trucks, and 7 delivery slots per truck.
Within each slot are 10 fields (Cust. name, location,
product, etc.). Each of these fields will be unique. So
that gives me 560 fields, plus a couple for date (primary
key) and day of the week. That is why I placed the
primary key on the date, there will never be duplicate
delivery schedule dates. So I have created 2 tables at
this point, with all the fields for 2 delivery schedules,
and in turn created the forms. What I am lacking, is the
knowledge to link the primary key (date) on schedule 2 to
the primary key (date) on schedule 1, and maintain the
primary key status for each individual form. I have
created a command button on schedule 1 that opens schedule
2, and what I am hoping for it to do is to open schedule 2
to the same date as schedule 1....if that makes any
sense. At the very worse, I guess I can create a command
button for "find record" on schedule 2, and have the sales
staff take the extra couple steps...but you know how that
works, every extra step is a chance for trouble. Once
again, thanks for your time.
Kevin
attempting to put together is a Truck Delivery Schedule,
in which I have 8 trucks, and 7 delivery slots per truck.
Within each slot are 10 fields (Cust. name, location,
product, etc.). Each of these fields will be unique. So
that gives me 560 fields, plus a couple for date (primary
key) and day of the week. That is why I placed the
primary key on the date, there will never be duplicate
delivery schedule dates. So I have created 2 tables at
this point, with all the fields for 2 delivery schedules,
and in turn created the forms. What I am lacking, is the
knowledge to link the primary key (date) on schedule 2 to
the primary key (date) on schedule 1, and maintain the
primary key status for each individual form. I have
created a command button on schedule 1 that opens schedule
2, and what I am hoping for it to do is to open schedule 2
to the same date as schedule 1....if that makes any
sense. At the very worse, I guess I can create a command
button for "find record" on schedule 2, and have the sales
staff take the extra couple steps...but you know how that
works, every extra step is a chance for trouble. Once
again, thanks for your time.
Kevin