Cascading combo/list boxes

[RuralGuy]

Do you plan to just keep adding on to one table for all of the different selections?

[MarkP]

I was hoping to add the contents of the form to a table as a record for each event (daily there could be 10 to 20 records) entered and to use the selections in listbox2 as a string in a column in the table that would be used for reports.

[RuralGuy]

Would this table just keep getting bigger every day that goes by?

[MarkP]

Yes the table would increase daily and help in trending reports.

[RuralGuy]

Almost there. We need to know what the fields of this table will be and where the values will come from and probably a value from the ComboBox so we can set that value for the filter criteria on the List2 RowSource.

[MarkP]

Thank you for your time. Let me briefly explain what I'm doing. I need to get an assessment of daily events that are analyzed by inspectors. These events would assist the inspectors in trending and focus their attention on problemt areas. I'm trying to capture their assessment in a database that would allow them to run reports. That said, presently, in the database I have two tables and one form. The form name is EventForm. The table that the combo/list boxes feed off of is tbl_CausalFacto rs. The table that the events are collected is tbl_Events. The causal factor table has 3 columns: CausalID (autonumber), Causals (text), and Factors (text). The event table has several columns but the main two are Causals and Factors and they are text fields. The combo box values would be things like: Alerts, Communications, Corrdination, and Automation for examples. I hope this helps.