Let me explain my problem the best I can.

I have a product database. This database has two fields SKU and Description.

Some of the SKUs have components and in some cases those components are actually already in the same database.

e.g. PT001 consists of FD01 & FD02. FD01 is in the same database but FD02 is not in any and it doesnt have to be.

What I want to achieve...

On the screen of PT001 i want to have list of components which I would be able to chosse from the drop down list (i know how to make this).

Once I select a component SKU from a list (FD01) I would like to have it's description automatically entered in the next field.

HOW to make these two fields (SKU and description) conected so when I choose one the other gets displayed automatically?:?

I hope someone can help me.

Thank you

FileMaker Version: 6

Platform: Windows XP

You want to do a self relationship.

Create a relationship that goes from the field in which you enter FD01 to the SKU field in the same table (file).

Then set the component description as a lookup based on that relationship.

Since your items sometimes have more than one component, you might consider creating a new table (file) to store these as line items.