Access 2003: Many to many combo box

[compooper]

Hi


I have a many-to-many relationship between:

table: Company
PK: CompanyID
CompanyName

table: InvoiceTypes
PK: InvoiceTypeID
InvoiceType

Junctiontable: mmInvoiceTypeCompany
PK: mmID
CompanyID
InvoiceTypeID

I need to make a form so that:
combo box: companyname
then with that selection it updates:
combo box: invoicetype

I got both the combo boxes to have the right data to appear, it just doesn't update.

If i select company A, you should see invocetype1
If I select company B, you should only see invoicetype1 and invoicetype3
But I see all of the, on every choice.
What am I doing wrong?

[pbaldy]

Is this what you mean?

http://www.baldyweb.com/CascadingCombo.htm

Note this technique doesn't work well in continuous view.