AnsweredAssumed Answered

Search multiple fields for one value and create a list

Question asked by ELBENNETT on Jul 8, 2010
Latest reply on Jul 8, 2010 by philmodjunk


Search multiple fields for one value and create a list


I have an order form created for my advertising department.  (there is a lot more to it but this is where I'm stuck)  On this form: a single order can run multiple times, so there are 14 slots available to enter in "run dates" Now I need to make a "run sheet"  Ideally this run sheet will print a list that shows all of the orders (Company, ad size and cost) that will run for a particular date.   So.... I'm guessing a portal is used?  How do i make my database search the 14 "run date" slots to form one list?  I am new to FileMaker but have worked in Access quite a bit in the past. So while I understand databases, all the names I'm used to are different (and a lot of the functions) and can't for the life of me figure out how to search what I need to do. Please don't bind my question by the terms I've used, any solution, or the best possible way to do this is preferred. And even teach me some FileMaker Vocab if you please :)