Jump to content
Sign in to follow this  
kbruyette

solutions wanted Cross Referencing

Recommended Posts

I am new to FileMaker and have imported my Bento database across successfully. Essentially what I have is a database of food ingredients (the main record name being the ingredient name). Within each ingredient is another data field called 'related ingredients'. Within this field is a list of ingredients that are compatible with the main record name ingredient. For example:

Ingredient Name: garlic

Related Ingredients: arugula

lemon

parsley

pasta

shrimp

and so on...

There are over 600 ingredients (record names) in the database, fully cross-referenced.

I am having a problem with FileMaker in that I can't get it to search for multiple things at once like I can in Bento.

For instance, in Bento, I can type in the search bar 'lemon garlic parsley' and it will spit out a list right away that shows only the ingredients (record names) in the database which share all of those three 'related ingredients' in common.

I am hoping someone can help me with either an existing template that already does this, or point me in the right direction to create a new one which will allow me to display a list of common ingredients in response to the entry of multiple search criteria, the same way I can in Bento.

Thanks in advance for anyone was has the answer to my problem!

-K

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Similar Content

    • By wedgeman
      We are working with a medical non-profit working in Latin America, running on much older hardware.  Seeking older individual or group/site license seats of FMP & FMS 13, 14, or 15.
      We need a bunch.  We could buy site license seats, or simple 1-off licenses.   
×

Important Information

By using this site, you agree to our Terms of Use.