Jump to content

Two Fields Link


This topic is 6493 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 6493 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.