Hello, I have the following tables:
Companies:
-----------
Company_ID (PK)
Company_name
etc
etc
Product CD:
----------
Company_account (FK)
Module A
Module B
Module C
Product Web:
----------
Company_account (FK)
Module A
Module B
Module C
Product Book:
-------------
Company_account (FK)
Module A
Module B
Module C
Cancellations:
--------------
Company_account (FK)
Company_name
Date_For_Cancellation
Product
I have created a cancellations form (tabular). The user enters the Company_account into the form, this auto populates the company_name. They then enter the cancellation date......up to this point im fine.
I then placed a Combo Box into the form. I want this combo box to show the product list (CD ,Web, Book) but only for the product that the company takes!! (im not interested in which modules for a particular product that the company takes)
So if Company A takes the Book. Only "Book" should be shown in the list. If Company B is listed in both the CD and Web table, then the options "CD" and "Web" should be shown in the Combo box. If company C is listed under all 3 Tables "CD, WEB & BOOK" should be shown in the combo box.
I normally use wizards to do anything like this but I dont think its possible.....with a wizard.
Could some1 help me. I think i need to have the combo box do 3 Queries to find out if the company entered into the cancellations forms exists (or where the count > 0) in the product tables. If it does then the relevent product should be made available on the list.
Any ideas please?
Last edited: