Solved

Filemaker Recipe Database using 3 tables.Need to 1.view Ingredients from Recipe table, and 2.add new ingredients.

Posted on 2003-11-25
3
1,189 Views
Last Modified: 2012-08-14
I am creating a recipe database.
3 tables.
The first has a table of oils, with  oil1, oil2, etc
The second table has ingredients, named ingredient1, ingredient 2, etc
The 3rd table is the Recipe table, Recipe1, Recipe2, etc.
    Each recipe is made up of a combination of oils and ingredients
         eg, Recipe1  Oil1, Oil2,  Ingredient1, Ingredient5
              Recipe2   Oil2, Oil3,  Ingredient2, Ingredient5
1.I want to be able to view the list of ingredients and oils from the recipe table by having a drop list of ingredients and oils. (Maybe by validating the field to come from the value list of ingredients and oils?)  
2.I also want to be able to add new oils and ingredients, either from the recipe screen, or by being able to go to the ingredient table, adding the ingredient there and returning to the recipe table via a script.
Thank you
Mani
0
Comment
Question by:ManiPalani
3 Comments
 
LVL 1

Accepted Solution

by:
Scurv earned 500 total points
ID: 9861437
Personally I would use the portal method to display your recipes.

Try this example i've knocked up and see if it is what you are trying to do - http://members.lycos.co.uk/scurv/filemaker/fm-index.html
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now