Invoice Details Complex issue I think

[DaniBoy]

Hello,

I have an invoice form where ofcourse I have a invoice detail subform, I got everything working fine so far, but now I need to do an update to this form and I dont know how to do this.

I have the following tables on my DB:

Clients
Products
Departments
Invoices
Invoice_Detail

Now each product will belong to a department, let say 1" PVC Tube belongs to the Department Pluming.

This is what I need to do, I open the invoice form enter all the invoice information, than I goto the invoice details, there is the tricky part, I want to select from a combo box the department of the product I will sell, once I selelct the department I want to selelct the product... The problems is that I only want to be able to see the products that belong to that department I picked.

How can I do that?


thanks if there is any example db will be great...

Daniboy

 

[KeithG]

Do they select the product from a combobox?

 

[DaniBoy]

Hello,

Yes they will also select the product from a different combo box on the detail form.

thanks

 

[KeithG]

Search the forum for cascading comboboxes and you should find an answer.

 

[DaniBoy]

I tried to do the example on the listbox combo example db but I just cant get it to work here is a copy of the database to see if you can helkp me out.


on the form Facturas=Invoices on the detail I need to first select the department and than select the product that is on that department.


Try it out, it keeps asking for the dept after I have already enter it...

thanks

daniboy

 

[DaniBoy]

sorry here is the attachemnet

 

[KeithG]

Can you post an example of you db and I can show you?

 

[DaniBoy]

thanks Keith,

I did upload it is called tools.zip

 

[DaniBoy]

Did anyone figured out how to do what I need to do?

On invoice details I have to combo boxes I first select the Department combo box, than I want the product combobox to only give me the products from that department.


thanks