C
cw
I have been struggling on the proper place to insert my Table - T1Types?
- This Table contains the following 4 records :Voice, Data, Voice & Data,
Point to Point
- Each Order should contain 1 of those 4 values
- Then each MainService will have 1 to 24 detail records
I think it needs to be part of the Table OrderDetails?
- Because T1 Type is the first question we ask when a new order is placed
- Followed by the MainService details which are 1 to 24.
On my current Tabbed Form I have a Drop-Down that asks for the T1Type.
Then I have a Continuous form that displays the 1 to 24 records.
On the top of my Subform, I also want to have a drop-down that says : How
Many Channels?
which then creates the subform records using strSQL code.
I have posted my relationships at this link:
http://cerberus.clearwave.com/jerry/T1_Relationship.jpg
and my Tabbed Form at this link:
http://cerberus.clearwave.com/jerry/T1_Form_Entry.jpg
Thanks for your help,
cw
- This Table contains the following 4 records :Voice, Data, Voice & Data,
Point to Point
- Each Order should contain 1 of those 4 values
- Then each MainService will have 1 to 24 detail records
I think it needs to be part of the Table OrderDetails?
- Because T1 Type is the first question we ask when a new order is placed
- Followed by the MainService details which are 1 to 24.
On my current Tabbed Form I have a Drop-Down that asks for the T1Type.
Then I have a Continuous form that displays the 1 to 24 records.
On the top of my Subform, I also want to have a drop-down that says : How
Many Channels?
which then creates the subform records using strSQL code.
I have posted my relationships at this link:
http://cerberus.clearwave.com/jerry/T1_Relationship.jpg
and my Tabbed Form at this link:
http://cerberus.clearwave.com/jerry/T1_Form_Entry.jpg
Thanks for your help,
cw