Start with these relationships:
MachinesList::__pkMachineID = PartsList::_fkMachineID
Machine_Part::__pkPartID = PartsList::_fkPartID
You can place a portal to PartsList on the MachinesList layout to list and select Machine_Part records for each given MachinesList record. Fields from Machine_Part can be included in the Portal to show additional info about each selected Machine_Part record and the _fkPartID field can be set up with a value list for selecting Machine_Part records by their ID field.
For an explanation of the notation that I am using, see the first post of: Common Forum Relationship and Field Notations Explained
Just to check that im on the right lines here... I need to make a new table (machine_part) with one field (__pkPartID) as well as add a new field to my parts list table (_fkMachineID). And then relate as above?
You would create a new table with at least TWO fields, _fkPartID and _fkMachineID. There would be no new field added to your PartsList table.
I somehow screwed that up. Here's what I should have posted:
MachinesList::__pkMachineID = Machine_Part::_fkMachineID
PartsList::__pkPartID = Machine_Part::_fkPartID
You can place a portal to Machine_Part on the MachinesList layout to list and select PartsList records for each given MachinesList record. Fields from PartsList can be included in the Portal to show additional info about each selected PartsList record and the _fkPartID field can be set up with a value list for selecting PartsList records by their ID field.
Thank you Phil, I have it all working :)