Solution / Tiki drink database / inventory / random drink

Description: I made a drink database I did that for a luau we had for the holidays. It's in filemaker pro 7.

Everything is straight forward, how to enter a new drink, how to manage your inventory, if you click on recipes it will give you drinks you can do with your inventory. If you click a Tiki God anywhere in the database you will get a random recipe. In there you have an inventory and drinks already there to make it more enjoyable.

I hope you enjoy it.

http://www.project-hyrule.com/cocktails3.fp7

Working Under: 7

Solution Status: Beta

Pre-requisites:

Author(s): marika

Date: 03/29/06

Credits:

Instructions / Other Info:

Disclaimer:

FM Forums does not endorse or warrantee these files are fit for any particular purpose. Do not post or distribute files without written approval from the copyright owner. All files are deemed public domain unless otherwise indictated. Please backup every file that you intend to modify.

Sorry but trying to connect to Your link gives me only garbage.

with mac osx 10.44 and Safari but also Explorer

pls help thx

ctl key + click the link

select download link file

for windows users right click and save target as

Or,

You could just upload the file and include it with your post.

I thought it was nice of me to save you the bandwidth since it was 1.2 meg but I can upload it.

There isn't a shortage of storage space on the Forum, only a limit in the size that can be attached (1.43 mgs).

Is the size of your file before or after it is zipped?

Lee

Hi Marika-

Fun, thanks!

-Raz

I am very happy you like it.

Did not know ! Now it works thanks

please one more question! Where can I order the drinks now ;-)

Ah good question! You can email, me but drinks sent as attachment are really sad compared to a nice concoction I am glad it works for you and if you find anything that's not friendly or you think that could make it better let me know.

I downloaded your file because I was interested to see how you were able to limit recipes that only included ingredients in the inventory. But I found that the same recipes showed up no matter what I had in the inventory. I guess this part of the design is not fleshed out yet. I would also recommend that all of your fields be labeled. For example when I was in the layout to change quantities in the inventory, I did not find the layout completely intuitive. I like the idea and will be interested to see later versions as I could use a system like this at my house!

If you trigger the recipe script or the menu script it will omit the drinks you don't have the alcohol or juices for. It works. I have 43 drink drinks in my database and here are 3 I don't see because I don't have some juices/alcohol in stock.

Now in the inventory layout you need to put 1 (the number one) beside the alcohol you have in stock and if you don't have it leave it blank.

The less intuitive part is how to enter a new drink (I never did this database thinking I would share it so that's why the fields are not labeled but a quick view at the layout would have done the trick). I repeat the name of the drink beside each item of the drink. Maybe that's where it went wrong you can look at the existing ones in the database that's why I left information in there, in case it's not so clear.

Maybe there was a better way of doing that but I am still learning, I will get there sometime.

Can you add a print layout that'll make pretty pattern that can be cut out and used for an umbrella for the drinks?

I too... just got garbage.