link your two tables in a relaitonship:
MainTable::ImageID = CoatofARms::ImageID
Format MainTable::IMageID on your MainTable layout with a value list based on CoatofArms::ImageID
Place the container field from CoatofArms on your MainTable layout.
When you select an Image ID in MainTable::imageID, the matching coat of arms image should appear in CoatofArms::ImageID.
Many thanks for your help, particularly as you have a head cold today!
The two tables I am using already have a relationship based on
TaxEntity --< TaxReturn >-- TaxOffice
TaxEntity::TaxEntityID = TaxReturn::TaxEntityID
TaxOffice::TaxOfficeID = TaxReturn::TaxOfficeID
The Layout is based on TaxEntity and includes fields in a portal on a Tab from TaxReturn and also has two fields from Tax Office not in a portal and not on a Tab.
Will adding a new relationship between the two tables affect any of the existing joins or workings of the database based on the existing relationship?
Not as long as you create a new table occurrence for this. See this tutorial for an example:
It creates two separate relationships between the same two tables, using an extra table occurrence to keep them separate.