andrewaldrich
Registered User.
- Local time
- Yesterday, 18:30
- Joined
- Jan 15, 2012
- Messages
- 17
Could use some quick help ...
have 2 tables / 2 forms
table 1 - Calendar
ID field
Date field - imported 3 years of dates
Zone field - drop down look up to Zone Table
mutiple other fields
table 2 - Production
ID field
Date field - down down look up to Date field in the Calendar table
Zone field - down down look up to Zone table
multiple other fields
Calendar Form
Contains the fields from the Calendar table, plus a 10 tabbed control (one for each of the zones noted above)
Production Form
Contains the fields from the Production table
After creating the calendar form, I am attempting to add the Production form as a sub form. The parent fields are the Date field and the Zone field. The child fields are the Date field and the Zone field.
The subform displays correctly, however doesn't behave correctly. I can add records to the subform with the date and the zone added automatically as part of the sub-form programming. If I need to change the zone, I can choose from a drop down and make the change. The record should "move" to the new zone tab. It doesn't.
If I add a record to the Production Table to test, it doesn't appear in the subform.
The DB relationship between the two tables is
Calendar [CalID] (autonumber) (one side) to
Production [MM DD YYYY] (many side).
I have tried tinkering with this for the last 2 hours to no avail. Seeking some quick help so I can keep moving.
Thanks!
have 2 tables / 2 forms
table 1 - Calendar
ID field
Date field - imported 3 years of dates
Zone field - drop down look up to Zone Table
mutiple other fields
table 2 - Production
ID field
Date field - down down look up to Date field in the Calendar table
Zone field - down down look up to Zone table
multiple other fields
Calendar Form
Contains the fields from the Calendar table, plus a 10 tabbed control (one for each of the zones noted above)
Production Form
Contains the fields from the Production table
After creating the calendar form, I am attempting to add the Production form as a sub form. The parent fields are the Date field and the Zone field. The child fields are the Date field and the Zone field.
The subform displays correctly, however doesn't behave correctly. I can add records to the subform with the date and the zone added automatically as part of the sub-form programming. If I need to change the zone, I can choose from a drop down and make the change. The record should "move" to the new zone tab. It doesn't.
If I add a record to the Production Table to test, it doesn't appear in the subform.
The DB relationship between the two tables is
Calendar [CalID] (autonumber) (one side) to
Production [MM DD YYYY] (many side).
I have tried tinkering with this for the last 2 hours to no avail. Seeking some quick help so I can keep moving.
Thanks!