Relating files within the same database

[forte]

:

I am creating a graphics database. I want to link a PSD file (record) to many BMP files (records) with in the database.

I would like to have the PSD file (record) show up in the records of the BMPs (that it is associated with).

If the PSD file is updated in the database, I want the psd file to automatically update throughout all of the other records.

Is this possible??? I am guessing that I have to do a one to many relationship. I have tried to do this but can not get it to work.

Any suggestion???

[goostree]

Add a field that will contain some sort of ID number. Create a new relationship based on the ID number. Enter your ID information into the ID number field. Make sure that if you want records X, Y, and Z to relate to one another, you enter the same ID in the ID number field.

You can view all the related records through a portal.