Form/Subform normalizing issue

[Lisa]

I have a db loosely designed on the Northwind db.
I have a Form - 'Orders' that contains the main Form and a subform as a
separate tab. The subform is for 'Special Orders'. The db is to be used
by a friend who opened a home-based dessert business. The Orders form
has a field 'ShipDate' to be used to populate a Shipping Calendar
report. No problems up to here.
My problem is Special Orders can be mailed 3x, 6x, 9x or 12x per year.
I had fields labeled ShipDate1 - ShipDate12 but realized they were not
normalized. I created a table - ttblSpecialOrdersShipping for the
OrderID and ShipDate. I am not able to put this all into a neat form.

I would like to have 12 fields on the subform where the user can enter
the shipping dates. The only way I have found is to create a third
subform containing the ShipDate field and insert that in the Special
Orders subform in continuous view. I know I am missing something to
pull it all together neatly. Does anyone have a suggestion?

 

[Amy Blankenship]

You CAN do what you want, but Access does not make it easy for you.

This is how I solved a similar problem:

http://groups.google.com/group/microsoft.public.access.queries/msg/7b1eace22c007082

-Amy