BlackWolf

The only real difference is that the Duty items have a 15% markup on the total. Other than that, they are the same. The idea of combining fields with a calculation is interesting... but it feels like a workaround. A lot of things have felt that way when I have been reading this forum. There is a way to do most everything, but it just might not be easy or straightforward.

I have been working with FileMaker redesigning a database for my work, and I have run into a problem time and time again. When working with other databases (such as MySQL), I often want to run a query something like this: [color:"blue"]"SELECT * FROM jobs WHERE job_number='1' AND client_id='7'". I have tried to get this [color:"red"]AND part into my FM databases, but I'm having trouble. Is there a way to relate two files using more than one related field? For example, I had a file called "materials" which has a radio button with the options "Duty Free" and "Non Duty Free". It would be nice to be able to pull up a report that lists all items which are "Duty Free", all the "Non Duty Free" items, and display totals for each with the $ amount of duty and the final total of everything. But I couldn't find a way to make a relationship that would show the items which had the correct job number [color:"red"]AND duty/non duty. The best solution I have found so far is to separate everthing into different files. So now I have two files instead for the Duty and Non Duty items. Does anyone know of a better way? Thanks!

Thanks LaRetta! I had tried something similar without much success, but I took your advice and it is working now. I had to add a few calculation fields to the Assignments file, but it is working this time! Thanks again.

I am new to FileMaker, but I have had experience with other databases. I am having trouble figuring out how to do a specific search. I have three files. One is called "Jobs" which keeps information on the jobs our department is working on. The other is called "Assignments" which keeps an Employee ID and a Job Number. The last one is called "Employees" that has the info on employees. I already have a relationship that links the Job Numbers from "Jobs" and "Assignments" and on one layout I have a portal that shows all the employees assigned to the job. What I want is to make a layout that will show the jobs that each employee is working on, so each week the boss can print out a report with someone's name on it and the status of all the jobs they are working on (which shows info from the "Jobs" file). Thanks for at least taking the time to read about my plight.