Hi All,
I need some guidance please.
I writing a query to gather data for a report. i have a print menu selection screen where criteria is selected from about 7 tables. not all tables will be applicable at one time. I have written in my query to display selected records in the different tables but I used "Or" criteria, meaning any selection made will display all records that meet the criteria including records from other tables not selected because of the "Or" criteria. So my question is, how do I go about to display only what is required. for instance if i select to see Spares from category table and Local from the customer Table, displayed will give all types of stock from the category table and all records from customers where. am I going about this all wrong?
I need some guidance please.
I writing a query to gather data for a report. i have a print menu selection screen where criteria is selected from about 7 tables. not all tables will be applicable at one time. I have written in my query to display selected records in the different tables but I used "Or" criteria, meaning any selection made will display all records that meet the criteria including records from other tables not selected because of the "Or" criteria. So my question is, how do I go about to display only what is required. for instance if i select to see Spares from category table and Local from the customer Table, displayed will give all types of stock from the category table and all records from customers where. am I going about this all wrong?