I'm working on an "internal parts database." We have an internal company part number and would like to cross reference / relate this to several different manufacturer's part numbers. As an example, we may have a black widget with internal part number WIDG001. We buy this widget from Widgetco as part number WIDGIWIDGI001 and the same item can be purchased from Wally's Widget World as part number WWW101A.
What's the best way to reference an internal part number field to multiple other fields in a single Filemaker DB?