R
Rohn
Most likely I am making this harder than it should be!!!! You Guru's may
laugh at this one, but I just can't get it.
The problem - The combo boxes only work where there is a unique
FRDF_CATEGORY.CHILD_REF=FRDF_CATEGORY.CATEGORY in the FRDF_CATEGORY table!
I thought I could get the Parent_ID/Child_ID concept to work but I couldn't
so I went with looking up the the CATEGORY and comparing it to the
CHILD_REF. I hope this makes since! But ideally, I should be working on
Parent_ID/Child_ID concept so that the combo box selection can be grown to
CATEGORY_C and CATEGORY_D. My query/lookup knowledge is holding me back
here. I can post my SQL lookups on each of the three combo boxes that I have
working but I think they need to change!
SQL2000 back end and Access2003 front end database not ADP yet. Below is
the table structure:
FRDF_CONTACT (table) mainform
ROW_ID - autonumber
C_DEFINITION - text
UNIT_ID - text
COMPLETION_DATE - sql select from a view based on UNIT_ID
RECORD_CREATE_DATE - date/time
FRDF_DETAILS (table) subform
ROW_ID - autonumber
D_DEFINITION - text
CONTACT_UNIT_ID - text (mainform subform link)
DETAIL_COMMENTS - memo
ORIGINATOR - sql select from a view
bla bla bla - other unrelated fields
CATEGORY_A - text
CATEGORY_B - text
CATEGORY_C - text
CATEGORY_D - text
CATEGORY_E - text
FRDF_COST - currency
bla bla bla - other unrelated fields
FRDF_CATEGORY (table)
ROW_ID - autonumber hidden on form, primary Key
PARENT_ID - text
CHILD_ID - text, child records of the RECORD_ID
CHILD_REF - current reference to category
CATEGORY - text, description of the incident saved in
FRDF_DETAILS.CATEGORY_(A-E)
ACTION_TYPES (table)
DISPOSITION_TYPES (table)
REPORTS (table)
SYSUSERS (view)
EMPLOYEE (view)
PARTS (view)
VENDORS (view)
REPRESENTATIVES (view)
Thanks for any insights you can give me!
Rohn
laugh at this one, but I just can't get it.
The problem - The combo boxes only work where there is a unique
FRDF_CATEGORY.CHILD_REF=FRDF_CATEGORY.CATEGORY in the FRDF_CATEGORY table!
I thought I could get the Parent_ID/Child_ID concept to work but I couldn't
so I went with looking up the the CATEGORY and comparing it to the
CHILD_REF. I hope this makes since! But ideally, I should be working on
Parent_ID/Child_ID concept so that the combo box selection can be grown to
CATEGORY_C and CATEGORY_D. My query/lookup knowledge is holding me back
here. I can post my SQL lookups on each of the three combo boxes that I have
working but I think they need to change!
SQL2000 back end and Access2003 front end database not ADP yet. Below is
the table structure:
FRDF_CONTACT (table) mainform
ROW_ID - autonumber
C_DEFINITION - text
UNIT_ID - text
COMPLETION_DATE - sql select from a view based on UNIT_ID
RECORD_CREATE_DATE - date/time
FRDF_DETAILS (table) subform
ROW_ID - autonumber
D_DEFINITION - text
CONTACT_UNIT_ID - text (mainform subform link)
DETAIL_COMMENTS - memo
ORIGINATOR - sql select from a view
bla bla bla - other unrelated fields
CATEGORY_A - text
CATEGORY_B - text
CATEGORY_C - text
CATEGORY_D - text
CATEGORY_E - text
FRDF_COST - currency
bla bla bla - other unrelated fields
FRDF_CATEGORY (table)
ROW_ID - autonumber hidden on form, primary Key
PARENT_ID - text
CHILD_ID - text, child records of the RECORD_ID
CHILD_REF - current reference to category
CATEGORY - text, description of the incident saved in
FRDF_DETAILS.CATEGORY_(A-E)
ACTION_TYPES (table)
DISPOSITION_TYPES (table)
REPORTS (table)
SYSUSERS (view)
EMPLOYEE (view)
PARTS (view)
VENDORS (view)
REPRESENTATIVES (view)
Thanks for any insights you can give me!
Rohn