Jump to content


  • Posts

  • Joined

  • Last visited

Siri's Achievements


Explorer (4/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. I'm sorry I don't have an answer for this question. But I did read that javascript will 'work' in web viewer if it is installed in your web browser. I am interested in finding a solution to post fields to a web site to automatically generate the response page and perhaps javascript could do it. I read this page recently: from a blog regarding javascript posting http://timjoh.com/javascript-post-variables-to-forms/ "It’s possible, and in fact very easy, to send POST variables with Javascript. I’m posting it here because I had some trouble coming up with a solution. The only thing you have to do is to put an HTML form on a site, and use Javascript to submit it. If you don’t want the form to be visible, you can have the fields hidden. Here is a sample HTML code: Use this JS function to submit the form: function jsPost() { document.theForm.submit(); } It can be called in any way, for instance in a hyperlink: Submit Or as an event, like on body load: " so my idea is that I generate a custom page with the correct field values then post them to the page im trying to generate. Maybe someone who knows something about this subject could interject here. Thanks, Lea
  2. Siri

    too many TOs

    Hi John, I watched the PowerPoint presentation from Kevin's site. Its an interesting way to look at the relationship graph. I have to think about how I could convert my graph into his style. One problem might be that I've started with the 'spider' type graph, since it began as the Business tracker solution downloaded from Filemaker. What I've added has been in groups mainly since I've only used the global prefs table occasionally. Is the method of having one or more global fields related to sub tables the main way you conserve TO's? My Layouts frequently have Fields from several different 'Anchor' tables as the relationships seem to be more Data or ERD driven. Some of the main groups are created from Inventory calculations that involve Ratios between Units and Unit Types e.g. the weight and volume of a cup of onions is a ratio between Types (like density) for onions. I would appreciate more info on the spider type RG. Thanks, Siri
  3. Hi, I have a data base where two tables are joined to each other in multiple ways. My problem is that on the layouts, I often want to display the names that go with the IDs(fk) of records from related tables. I'm finding that in order to display the name, I'm looking for it is sometimes 3 or more relationships away. So I have to create intermediary TO's and rejoin them to the layout TO. Is this the proper way of handling the display of data when you are frequently repeating the same relationship but from a different TO. Example: Ingred Table w/Type RatioID fk joined to Type Ratio table w/Type ID fk joined to Type table w/Unit ID fk joined to Unit Table I would create a series of TOs to display the Unit Name. Except I have to recreate the same series of TO's everytime I want to display the Unit name which is related to that ingredient. Is there a way to reuse the same series of TO's everytime I want to perform this task? Thanks for any help. Siri.
  4. Is it possible to make a value from a relationship that has a many to many join table. 1stIngredient Table ID BaseUnitTypeIDfk Name BaseUnitIDfk 2ndJoin Table: For Ratio of different Types ID IngredientIDfk BaseUnitTypeIDfk TypeIDfk Ratio (between Type of Ingredient and a second type) 3rdType Table ID TypeName 4th Unit Table ID UnitName TypeIDfk Each Ingredient has a baseunit and a basetype. You can define ingredient specific units like clove (garlic). In the many join table you can create a ratio to other more standard types like mass in g or to other ingredient specific types like head (garlic). There you create a ratio like there are 22 cloves in a head of garlic. I'd like to have a value list that I could reuse in other table's layouts that show the units that are related to the types that have been defined for one ingredient. If the unit doesn't appear the user would have to define a new type ratio. Here is a sample file with the unit conversion. unittype.zip
  5. I've worked out a solution but its more geared towards cooking than using density. Usually each unit belongs to a type like mass or volume. I've created more units like clove, Case, or head that belongs to its own type of the same name (Case unit, of the group Case type) This way you can connect each ingredient and their base unit to any other unit/type combination. It requires regular relationship to the conversion to g/mL and a relationship which is a double relationship of ingredientID and type Id with a many to many join table. You do a conversion by multiplying the two ratios together basically. I'll attach the file if anyone has any comments. unittype.zip
  6. I have a recipe a shopping list database that is working okay. There is: Parent Table: Recipes Child Table: Ingredients with fields: ID Quantity unit (fk) ingredient name (fk) Converted Quantity Converted Unit (fk) the units are stored in a separate table with fields: ID Unit name type (mass,volume,count) ratio of unit to mL or g So when you enter an ingredient a base Quantity/unit and then when you enter a unit to convert to the ingredient record calculates the conversion Quantity to go with the new unit. I use this Quantity to sum up on the Shopping list. That works okay. The problem is with the types of ingredients obviously it becomes difficult to convert from mL to g as the conversion ratio is not the same for different ingredients. Sometimes recipes refer to the same ingredient with volume and mass units. So I'm trying to think up a way to have have special conversion table for conversion between types. I'll work on a sample database and post it. I have this idea that you could put the base unit in the ingredient table with the type then have a many to many join table to the ingredient specific ratio table. The ingred specific table would carry a fk of the regular unit that you are converting to. So a conversion from mass to volume would have 2 ratios you would multiply together, one for the g to mL and, one for the base unit to g. I am having trouble implementing this idea. That sounded as clear as mud. Any input would be appreciated. Siri
  7. Hi I had the same idea as you (making a recipe database) as I want to graduate to an inventory system. I created a table for the recipe and a subtable with quantity, unit and ingredient name. Then a unit database related to the unit ID in the recipe ingredient subtable. For each unit I had a name and a conversion factor to mL or mg. Back in the recipe screen I created a field for original number of portions and a "required portions" In recipe ingredient subtable, I created a field for conversion unit (ID) that you could choose from a dropdown names from the unit table and then used a simple calculation to fill in the converted quantity of units based on the metric amount of original units and required portions. So this brings me to the shopping list (I haven't added a way to subtract what I have yet), but I'm working on a yes/no field in the recipe table for whether I want to buy the ingredients for that recipe (for the required number of portions). I intend to copy that yes/or no to each ingredient in that recipe and then sum up each ingredient for each yes ingredient thus creating a shopping list. I'll email you what I have if you let me know you want it. I'm at siriuslea@hotmaildotcom. Let me know if you're still working on it. Siri
  8. I have a vendor table that is related to the product table. Each vendor-product combination has a price. I enter a quote (price)record in a separate table and the vendor product price updates to match the most recent quote, using a lookup. I'd like to update the price also by taking the last price from the invoice items. Should I just write a script to create a new quote record every time I enter a new invoice item? Is this the best way to update a field from multiple different layout/tables?
  9. The way I understand it, you can perform a relationship where you can relate to any of the values instead of all of the values by using a repeating field. (Please post any other way to accomplish this) I have 2 tables one categories and one items. I'd like to be able to show a portal with items from more than one category based on someone choosing several categories. I believe a checkbox field would do this and would place the selections in a repeating field? But I really have too many categories to put in a checkbox list. I'd like to base the selection (and repeating field) on a yes/no button for each category in a portal. I'm wondering if there is a way to do this.
  10. Siri

    Cascading Portals

    The Layout I'm working on is VendorItemDisplay Cascadetrial.zip
  11. Siri

    Cascading Portals

    I am trying to use a set of three selection portals to pick the Items to display in an item purchase history. The portals are Groups(of Items), Items, VendorItems (Items sold by a vendor). The Main display portal should display VendorItem purchase history. How it works now is you click on a GROUP name(in FIRST portal), the list of ITEMS in that group displays in the SECOND portal, you click on a item in the second portal and it displays the list of VENDORS that sell that item in the THIRD portal. This will create the main portal to display that vendor item history. The thing i'd like to change is, I'd like the first two portals (group and item) to display all records before you make a selection. Also I'd like to be able to choose more than one record and have the next portal show a combined collection of records related to those parent records. I'm not sure where to start whether I should use a repeating field or multiple fields. I will post my file in the next post. Siri
  12. Here is a file I added a table, a few relationships and a Cascade Layout that does what I think you mean. I'm not sure if you intended to choose the Workshop Name and then it shows different Locations? I also created a little script but didn't use it. Goodluck, Siri PS I'm a beginner too,so I might do things in a unique way? 1136865898-HelpAltered.zip
  13. I was posting before reading the replys of the others and I see more what you are talking about (unrelating). You could take the difference between the 2 figures to post to losses or whichever. For me, I think there maybe some other factors but might be possible to work through. Thanks for that flash of an idea. Siri.
  14. I didn't originally see the key of your idea (unrelating only after counting). This seems like a novel idea. I'm not sure if unrelating to the product table is a good idea but you could create a separate fk in another table and change that foreign key to do it (thats just an instinctive opinion). There would be less consequences for the products that way and you'd still be able to display product price history etc. I have to think much more about the design of this part of the database before I'd be able to offer an opinion re:filemaker. I only know how my current pc/restaurant system works.
  15. Hey Rick, Seeing as you have a dev working on your POS now, do you think that you could share it with the rest of us peeps that are trying to develop a customized version. Ha! Just kidding. I understood where you were coming from with your wishes for a free more fully realized POS but obviously you don't want to give away the work you are paying for as all labour requires some payment. The 'some' is the 'operative' word as most systems cost in the thousands (the one I'm trying to replace was over $5000) which seems like quite a lot for something as you said before is very similar for every small business out there. Siri.
  • Create New...

Important Information

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