Jump to content

Mary Butterfelder

Members
  • Content Count

    18
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Mary Butterfelder

  • Rank
    member
  1. Hi Eos, I asked this question about the filter for the portal...I don't think it's workable in FMGo. What would we do alternatively? if anything? The list of ingredients is about 970 long and bound to grow...but I don't think it's the size, I think it's just the way FMGo handles the filter script by popping up the keyboard, etc. Thanks, M http://fmforums.com/forum/topic/89640-filtering-a-portal-and-behaviour-in-fmgo/
  2. Hi, I have a solution that I have received much needed help from by FMForum members and part of the solution is to filter a portal from a long list (1000 records). the application is to be used on an iPad and the filter doesn't behave very well in FMGo with the keyboard popping up and a dialogue asking me if I want to discontinue the script...I did a search and nothing came up. Is it just intuitively obvious to experts (not me for sure) that you simply don't filter portals for fields that will be used in FMGo? If so, what do you do? I'm filtering a list to select the item for use in another ta
  3. wow, my jaw just dropped...so I will work with this and incorporate what Fran and Fenton had done earlier... and yes if you do get to Vancouver or Seattle or Portland (a long way from where you are!), you have four reservations waiting for you for dinner at no cost of course. But, I must warn you, this is ultra healthy-gluten free-no processed sugar-no dairy kinda food!!! so I'm sorry to say, no cheesecake...but we may have a recipe for a dairy free cheesecake by then...using goat milk instead...working on that now! I would certainly send you the recipe! Same goes for Fenton and Fran..
  4. okay, I've had a bit of a chance to look this over and eos, you resolved the ingredients/suppliers problem very nicely! thanks! now here is my next problem: I have the solution working on the Chef Recipe Ingredient side with the portals, etc. thanks to Fran and Fenton. Now the supplier side is more complicated so, with my rudimentary knowledge, will it be tricky for my to integrate the two? and if not, I imagine that it would be better to add what I have for Chef Recipes Ingredients to the more complicated Recipes Ingredients Suppliers that you just finished? I know it's hard for anyo
  5. thanks Fenton, thanks Eos...you guys amaze me! okay, I'll study this...
  6. Hello Fenton. I want to thank you so much for your help thus far. I have now got all my needed calculations working as you have indicated above. Working fine! woohoo! Thanks! For the past few days, I've been trying to get the supplier | ingredients relationship to work and have failed and I'm afraid I need your help once again! here's my thinking... One Chef has one or more Recipes One Recipe has one or more Ingredients One Ingredient has one or more Suppliers A recipe can have ingredients from different suppliers and there are different costs from each supplier I could
  7. Thanks! Yes, sorry, we're in Canada and grams is a metric unit of mass as pretty much everything we purchase in bulk is sold in 100 gram quantities. In the states it's by the once or pound. Up here, primary ingredients like meats and fish are mainly sold by the Kilogram...we are also in Seattle, but we are not tracking what's going on with costs in Seattle as the restaurants are a little behind us. okay, I'll have to fiddle a bit...thanks again...I will likely have to come back with questions...I hope I'm not becoming a bother! Mary
  8. Okay, thanks for that. It's great to know that there is support for this application beyond what one can glean from the online and printed materials...which all seem far too simplistic to really make a difference in real world applications. I've changed the naming scheme and have added the join table to SUP__Supplier linked to sup_supplier | Ingredients linked to sup_supplier | ingredients_Ingredients linked to SUP_Supplier 2. Is that correct? I'm trying to follow the same logic as what was created for the Recipes TOs. Another question Fenton...I need to do add fields to ingredients f
  9. Thanks Fenton and many thanks to Fran for doing the file, which is what I am trying to accomplish. I do have FMPro11 and bought it last year when I was going to try this out, but never got around to it. upgraded it since but thanks for thinking of me! Thanks too to others for your input. I will give your suggestions a go Fenton, as yes, different ingredients will have different suppliers with different costs...I think if I follow the logic Fran has applied, then I should be okay...learning curve is steep though...it still amazes me how one is to learn the nuances and I guess it goes to sh
  10. Yes, I hear you. Fran just did what I've been fiddling with for days probably in an hour or so! It does speak volumes to the forum and to the skills of the expert members. It also speaks to the possibilities in fm that go far beyond what documentation describes. I would imagine most of the expert members here are consultants. So, I would feel very safe hiring someone to do more on my database when my little club hits high gear. Right now, it's kinda in 2nd gear...good luck to you Mike!
  11. It seems to me like I have this totally wrong. Can anyone offer some advice? It seems to me that a recipe is simply a summarized view or preview of a bunch of ingredients that I assign a recipe name to, and to which is owned by a chef. Isn't that right? So, if I create a recipe and assign it a name, I can just add ingredients and as long as I assign it to the same recipe name?
  12. Yes, when I first set it up, I had global storage turned on in both. I have changed both fields to 'indexing all' in the middle table, but still can't get it to work.  Trying different things...it seems this is more trial and error than anything at this point.  Â
  13. Thanks for your welcome Tom and thanks for your help...I'm trying to piece this together given your advice so I have changed the structure as in the attached graphic. Sorry, I have questions as that did not get me very far I'm afraid  Once I create the join table between recipes and ingredients, I assume that the Recipes/Ingredients Layout uses records from the join table I just created? I cannot get the recipes that are created in the Recipes table for a particular Chef to appear in the portal in the Recipe/Ingredients layout...so it follows that I also cannot get the ingredients to di
  14. Hi Mike! I was looking this over and tried to glean some ideas from the thread but your database is quite complicated. I have a thread a few down about relationships in a recipe database. How did you discover how to get all those portals to work? Trial and error, forum help, or just a quick study? Was there somewhere in particular that you went to learn about relationships other than the FM Support Forum or the FMPro missing manual? I have been to both and didn't help in a direct, quick sense of the word help. Does trial and error help when trying to get these things to work when one doesn't q
×
×
  • Create New...

Important Information

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