Difficult (for me) relationship problem.

Using Win-8.5 advanced.

I have a senior snag trying to get my arms around a project for tracking
maintenance for a fleet of boats (or cars, etc.)

I have the Tables below
Vessel Info
...Vessel Name, Model, manufacturer, Vessel_ID
Mechanical Components
...Type (Engine, Transmission, Generator, etc.) Vessel Name,
Component_ID
Parts (for Mechanical Components)
...Type (Oil filter, Air FIlter, Lube oil, etc.) Vessel Name, Part_ID

I link Vessel Info to Mechanical Components via Vessel Name.
I link Parts to Mechanical compenents via Part_ID

In the portal on Mechanical Components, I can create new part records OK

I want to go to a Parts record and show which Vessels and which Mechanical
Componets use this part (via a portal).

Curently, each Parts record shows the Vessel & Mechanical Components which
uses it, but i'd like a summary (so to speak) via a portal.

Any ideas.



--
-------------------------------------------------
Captain Guy
s/v Island Time (Beneteau 352#277)
AICW 845.5
386-689-5088


.

Relevant Pages

  • Re: Difficult (for me) relationship problem.
    ... tracking maintenance for a fleet of boats ... ...Vessel Name, Model, manufacturer, Vessel_ID ... ...Type (Oil filter, Air FIlter, Lube oil, etc.) Vessel Name, ... I link Vessel Info to Mechanical Components via Vessel Name. ...
    (comp.databases.filemaker)
  • Re: Difficult (for me) relationship problem.
    ... ...Vessel Name, Model, manufacturer, Vessel_ID ... I link Vessel Info to Mechanical Components via Vessel Name. ... Instead, define a primary key ... relationships of the database. ...
    (comp.databases.filemaker)