@fritzo2: "How do I display records that match a) supplier AND b) work_order#
 from file Order_items
into a portal in file Orders?
FMP6"
    @rnmenegaux: "<quote>
Again (it has been said often), uses the filter : 'Supplier_ID & " / " & 
work_order#'. I generally call that combined filter 'Token'. I may then 
have various Tokens.
With more details for one Supplier and one Suppliers and one work_order# 
:
File A is the one you are in. In A you create a global 'gSupplier_ID' 
that with be filled by one Supplier_ID' from a list by example and an 
other global 'gwork_order#' filled with oned 'work_orders#'. The 
relationship between A and file B will be done on A with 'gSupplier_ID & 
" / " & gwork_order#' and on B with 'Supplier_ID & " / " & 
work_order#''. Then in A you show a portal of B based on that 
relationship. But if you want printing, you do it in B, because of the 
variable number of lines in B.
If you want one Suppliers and all work_orders of that Supplier, you make 
another relationship based on 'gSupplier_ID & " / " & work_order#' on 
the left (A), and 'Supplier_ID & " / " & work_order#' on the right (B).
If you want all Suppliers and all work_orders, you simply make another 
relationship based on 'Supplier_ID & " / " & work_order#' on both sides. 
You sort them properly in the portal automatically.
Remi-Noel"
    @usenet: "<quote>
In FM7 you would set the relationship, by connecting your files by
supplier, then find the '=' box between them, double-click on it, and
add 'work_order' to the relationship. No idea if it would work in FM6. 
Catja"
{'source': 'USENET', 'other_information': '{"reply_count": 2, "forum_name": "comp.databases.filemaker.20150609.mbox"}', 'file': 'data/output/usenet-comp.databases.parquet'}