Hello, everyone, I am new to filemaker.
Now, I am facing a problem that is,
In my database, I have a portal. I would like to automatically enter text and numbers. For example,
when I choose main dish(food name field) in a portal, another field(order field) in the same portal will show beef and 'quantity field' will show the number 5.
Is it possible in filemaker?
I have tried writing a calculation value and data in field setting, but there are no words or number showing in the order field and quantity field.
The calculation is like "If ( food name = "main dish" ; order = "beef" )"
Could anyone tell me how to solve this problem? Thank You