Calculation Question

[Law Of Seven]

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

[RalphL]

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.

[Law Of Seven]

I got it working.

Thanks

Law Of Seven