Completed

programming of selection menu on Restaurant Costing Database in Filemaker

I own a small restaurant, and have created a Filemaker database that could use a little tweaking that is outside my skillset. I made this database to allow us to calculate the food cost margin on all our menu items.

The challenges that led to this were:

1) Food input costs are always changing, so if tomatoes go up 30% in price, I need to calculate how that cost of BASE INGREDIENTS ripples into all our menu item costs

2) We often ‘make’ a secondary ingredient in-house (say salad dressing) that then gets used in menu items (salads), so I needed to create a ’SECONDARY INGREDIENT) category that then can be costed out in a basic unit (say ml) and then used in primary menu items

3) We sometimes use the ’secondary ingredients’ (say the salad dressing above) in creating a third level of ingredients (say chicken based in the salad dressing that is it’s self a secondary ingredient), so I needed to create a TERTIARY INGREDIENT that is composed of base and secondary ingredients and can be used in constructing individual item recipes.

You will see this in the forms for

BASE INGREDIENT

SECONDARY INGREDIENT, and

TERITIARY INGREDIENT

which then can all be called upon to form

MENU ITEMS

This all seems to work great. The thing I need help with, is at this point the list of BASE INGREDIENTS is getting really long, and the drop-down menu when you are creating MENU ITEMS is too big and imposing. However I created a ’Type of Ingredient’ classification that corresponds to the base ingredients (one base ingredient could have one (such as milk which is ‘Dairy’) or many ’Type of Ingredient’ classifications (such as ‘Butter Packets’ that can be the following Types: Dairy, Condiment, or Seasoning).

What I would like to do, is on the portals for selecting the BASE INGREDIENTS when constructing MENU ITEMS’ or SECONDARY INGREDIENTS or TERTIARY INGREDIENTS have the first drop down menu allow you to select INGREDIENT TYPE first which then limits the selection of BASE INGREDIENTS that show up in the BASE INGREDIENT drop down menu by this selection… so for instance if I choose ‘DAIRY’ first as an INGREDIENT TYPE, the BASE INGREDIENT drop down menu to the right of it will only show ‘DAIRY’ products when it is activated.

Does that make sense? The current version of the database is attached to this project request. Can you give me a cost to do this work?

Skills: FileMaker, Database Programming, MySQL, SQL, PHP

See more: database filemaker services, folder menu restaurant, free menu restaurant adobe, folder para menu restaurant, java menu restaurant project, embedded media player selection menu, folder menu restaurant template, unusual menu restaurant, caller restaurant customer database system, restaurant order database, paper menu restaurant template free, size menu restaurant indesign, restaurant menu menu item price database relationship

About the Employer:
( 0 reviews ) Winnipeg, Canada

Project ID: #25650988

Awarded to:

FMMasterMinion

Hi, Hope you are doing good. I am FileMaker developer for the past 7 years. I have read your requirement and checked the file and did the change you requested in BASE INGREDIENTS part. Ping me I will show you the de More

$130 CAD in 3 days
(1 Review)
0.8

10 freelancers are bidding on average $182 for this job

samhegazy

i am a senior database developer and i specialize in data management and building management system for companies I am sure that i can build this database for you and help you maintain it to fulfill your goals. for my More

$250 CAD in 7 days
(26 Reviews)
6.4
bonech

Hello, I’m full stack professional Filemaker developer using the last technologies. You’re looking for a Filemaker developer for your project and this is exactly what I specialize in since decades. Talk about a perfe More

$250 CAD in 7 days
(26 Reviews)
6.5
DeveloperYrik

Hi, Web Senior Expert Here! Thanks for giving me a chance to bid on your project. As you can see in my reviews and portfolios, I have done lots of web project using databases before so I can help you. If you hire me, I More

$50 CAD in 2 days
(5 Reviews)
5.3
SRPTL

Hi i absolutely understand what you want in your Restaurant costing Database that you built using Filemaker. I will help you to achive what you wanted as you want to shrink your BASE INGREDIENT drop down list by INGRE More

$250 CAD in 5 days
(24 Reviews)
5.1
(5 Reviews)
4.3
MooRabie

Hello, I am a full time FileMaker developer, I mainly develop custom management solutions for companies and Individuals. I am a FileMaker developer with 8 years experience, specializing in FileMaker systems and data More

$190 CAD in 5 days
(2 Reviews)
3.9
$156 CAD in 3 days
(0 Reviews)
0.0
(0 Reviews)
0.0
vg3dart

Hi. I have read your job description and I am very interested in your job. I think that it will take about 3 hrs to do this job. It will cost about 100USD. Pls let me know if you are interested. Regards, Viktor.

$140 CAD in 7 days
(0 Reviews)
0.0