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!
