R
Rohn Everson
Our Customer Service team wants to track incoming field response
calls/requests. So, I have a simple form/subform but I am at an impasse as
to how to get the subforms cascading combos to work in the main form. They
worked great in the subform prior to placing it in the main form. Is this a
limit of Access or do I need to design the combos differently in a subform
situation?
The problem - I get a prompt to "enter the parameter value" but it should be
getting the parameter from the previous combobox!
SQL2000 back end and Access2003 front end database not ADP yet. Below is
the table structure:
FRDF_CONTACT (table)
ROW_ID - autonumber
DEFINITION - text
UNIT_ID - text
PROBLEM_DATE - date/time
REP - sql select from a view
ORIGINATOR - sql select from a view
DEALER - sql select from a view based on UNIT_ID
END_USER - sql select from a view based on UNIT_ID
COMPLETION_DATE - sql select from a view based on UNIT_ID
RECORD_CREATE_DATE - date/time
bla bla bla - other related data
FRDF_DETAILS (table)
ROW_ID - autonumber
DEFINITION - text
CONTACT_ROW_ID - number (mainform subform link)
DETAIL_COMMENTS - memo
bla bla bla - other unrelated fields
CATEGORY_A - memo
CATEGORY_B - memo
CATEGORY_C - memo
CATEGORY_D - memo
CATEGORY_E - memo
FRDF_COST - currency
bla bla bla - other unrelated fields
FRDF_INCIDENT (table)
ROW_ID - autonumber hidden on form
RECORD_ID - text, primary Key
CHILD_ID - text, child records of the RECORD_ID
CATEGORY - text, description of the incident
ACTION_TYPES (table)
DISPOSITION_TYPES (table)
REPORTS (table)
SYSUSERS (view)
EMPLOYEE (view)
PARTS (view)
VENDORS (view)
REPRESENTATIVES (view)
calls/requests. So, I have a simple form/subform but I am at an impasse as
to how to get the subforms cascading combos to work in the main form. They
worked great in the subform prior to placing it in the main form. Is this a
limit of Access or do I need to design the combos differently in a subform
situation?
The problem - I get a prompt to "enter the parameter value" but it should be
getting the parameter from the previous combobox!
SQL2000 back end and Access2003 front end database not ADP yet. Below is
the table structure:
FRDF_CONTACT (table)
ROW_ID - autonumber
DEFINITION - text
UNIT_ID - text
PROBLEM_DATE - date/time
REP - sql select from a view
ORIGINATOR - sql select from a view
DEALER - sql select from a view based on UNIT_ID
END_USER - sql select from a view based on UNIT_ID
COMPLETION_DATE - sql select from a view based on UNIT_ID
RECORD_CREATE_DATE - date/time
bla bla bla - other related data
FRDF_DETAILS (table)
ROW_ID - autonumber
DEFINITION - text
CONTACT_ROW_ID - number (mainform subform link)
DETAIL_COMMENTS - memo
bla bla bla - other unrelated fields
CATEGORY_A - memo
CATEGORY_B - memo
CATEGORY_C - memo
CATEGORY_D - memo
CATEGORY_E - memo
FRDF_COST - currency
bla bla bla - other unrelated fields
FRDF_INCIDENT (table)
ROW_ID - autonumber hidden on form
RECORD_ID - text, primary Key
CHILD_ID - text, child records of the RECORD_ID
CATEGORY - text, description of the incident
ACTION_TYPES (table)
DISPOSITION_TYPES (table)
REPORTS (table)
SYSUSERS (view)
EMPLOYEE (view)
PARTS (view)
VENDORS (view)
REPRESENTATIVES (view)