L
Lisa
I have a db (I am designing for a friend who opened a home-based
business) with date issues.
Table - Orders - has order specific information (OrderId, CustomerID,
ShipDate, etc...)
Table - OrderDetails - has order specific information (Product,
quantity, etc...)
Table - SpecialOrders - has information on special orders
(SpecialOrderID, product, quantity)
Table - SpecialOrdersShipping - has SpecialOrderID, ShipDate
Form - Orders has two tabbed sections. Tab one contains information on
regular orders bringing the tables Orders and OrderDetails together in
a query.
The second tab is for special orders.
Special Orders can be shipped 3x, 6x, 9x or 12x per year. I am trying
to design a form where for each SpecialOrder one can select multiple
dates for shipping. I tried adding a subform with the field ship date
12 times. As soon as I enter a date in one field the rest fill in with
the same date. Originally I had twelve fields named ShipDate1 -
ShipDate12 but this does not avail itself to a shipping calendar
report.
I can send any more specifics you need. I have been trying for weeks
and can't get anywhere. ANY HELP is greatly appreciated.
business) with date issues.
Table - Orders - has order specific information (OrderId, CustomerID,
ShipDate, etc...)
Table - OrderDetails - has order specific information (Product,
quantity, etc...)
Table - SpecialOrders - has information on special orders
(SpecialOrderID, product, quantity)
Table - SpecialOrdersShipping - has SpecialOrderID, ShipDate
Form - Orders has two tabbed sections. Tab one contains information on
regular orders bringing the tables Orders and OrderDetails together in
a query.
The second tab is for special orders.
Special Orders can be shipped 3x, 6x, 9x or 12x per year. I am trying
to design a form where for each SpecialOrder one can select multiple
dates for shipping. I tried adding a subform with the field ship date
12 times. As soon as I enter a date in one field the rest fill in with
the same date. Originally I had twelve fields named ShipDate1 -
ShipDate12 but this does not avail itself to a shipping calendar
report.
I can send any more specifics you need. I have been trying for weeks
and can't get anywhere. ANY HELP is greatly appreciated.