I have 2 tables and 1 join table. Employees Join Table Vehicle I have it set up so an entry in either Employees or Vehicle creates a new record in the join table so if you're in either table, the relationship will show up on either side. So I have a portal on Employees and Vehicles from the Join Table. In the Portals are the fields from the join table. These fields are drop down value lists. From fleet it looks at Employee name and from Employee it looks at Vehicle Descriptio
Filemaker, Inc. keeps changing rules on me every new version. Here's the updated file for version 9. Explanation: In version 9, a field used to match a Number field in a ≠ relationship is considered empty, unless it has an actual number in it. DwindlingVL.fp7.zip
