Hello

I am very new to Filemaker so I'm sure there is a simple answer to this, but I just cannot figure it out.

I have 2 tables: Jewelry and Sales

In the Jewelry table I have the following fields

Name (Text) - example "N 042"

Short Description (Text) - example "Garnet and Pearl"

Category (Text) - example "Pendant"

Price (Number) - example "120"

In the Sales table in addition to basic sale information like order number etc I have a list of each piece of jewelry that was sold as part of a particular sale.

Name (Text [10])

Short Description (Text [10])

Category (Text [10])

Price (Number [10])

What I would like to be able to do is have the user type in the Name in the Sales table and then have the remaining three fields get their values from a calculation, so that users only have to type in the name and everything else is automatically retrieved from the correct Jewelry record.

I have defined relationships between the 2 Tables

In MySQL I would simply do something like this to calculate the related Short Description.

SELECT Short Description FROM Jewelry WHERE Sales::Name LIKE Jewelry::Name

and etc for Category and Price

Any suggestions on how to do that in Filemaker?

Thanks in advance

Law Of Seven

It lools like you are using repeating fields, replace them with a line items table. Make a relationship between the line items and Jewelry tables. Use lookups in the line items to get the values from Jewelry.

I got it working.

Thanks

Law Of Seven