Hi. I am completely new to FileMaker as I have just moved to a new working environment. I am not very sure if I am posting at the right place but here is what I need help when trying to learn more about FM.

I have created 2 simple tables:

1) Product Catalogue

2) Invoice

I have 3 fields in Product Catalogue:

1) Product Name (text)

2) Product Number (auto-generated serial number)

3) Price

In invoice, I have:

1) Product Number (text)

2) Product Name

3) Price

I am hoping that I can key in the product number in the invoice, and have the product name 'appears' on its own, based on the table "Product Cataloge". I have tried to apply relationships but it doesn't seem to be working... I have also tried some calculations but have no luck yet...

I hope this question is not too silly to ask. Many thanks in advance!

Hi

you'll need a new table: InvoiceLineItems

Erm sorry I don't quite understand. I am totally new with FM. What should this new table contain?

You can do an advanced boolean search for +lineitem or +line +item and you will come across many posts reading this subject.

Basically, you have an invoice and the line items table is where you would store the order details of the products that one ordered on the invoice. Things such as productID, invoiceID, qty, price (from product table), linetotalamt, etc.