combo boxes

[holden_1]

hi
I have a cascading combo box on a form where by you can first select a supplier of a part and then a part from that supplier. (Attached is a pic of my structure). Next I want to be able to create a record of a "complaint report" for that part in the combo box... (see structure). Any ideas?
Many thanks,
Rob

 

[grnegsndhm]

You can use several combo boxes to do this.
In the query for the Combo box build in the where clause the path to said combo box.
condition = combo.column(1)

'Requery' each subsequant combo box when a its parent information changes. This will refresh each combo boxes contents.

Hope this helps