You want to find a combination of two fields (customer and produkt) in a remote table.
[Hint] If you have a chance to upgrade to FM 9 this problem would be much easier because the new versions support realtionships with multiple conditions.
But it is also possible in your version. You need a calculation field combining both fields
product &"-"& customerin both tables. Then you connect the new fields with a relationship. It will show only related records which exactly match in both conditions.
Danke! This works great! I appreciate your help and your quick response. May I ask one more question? How do repeating fields work in this situation? (i.e. the Press Type can change from print to print...if it were a repeating field with all the possible Press Types would the user be able to select the appropriate one?) Does FileMaker just use the first record or is there a way to let the user select which record to use?
Thank you for your post.
A repeating field is a single field that contains many values. In a calculation, to use a field with a repeating field, use the Extend() function. For example, if you want to use a non-repeating "Product" field with the repeating "Press Type" field, the calculation would be:
Extend (Product) & Press Type
In the calculation, make sure you specify the number of repetitions. Otherwise, you will only see the first value.
If you want to select a specific repeating value, it can be a bit cumbersome. You would need to create an additional checkbox field and a repeating calculation field that when the checkbox field is checked the value from that repeating value is used, and then use another calculation field to grab the value from the repeating calculation (through use of Max function).
Although Repeating fields are easy to use, they can be very limiting in the long run. As you gain more knowledge with FileMaker Pro, you should look at converting these repeating values to separate records in a related table.
Good luck, and let me know if you need clarification for any of the above steps.