Jump to content


  • Posts

  • Joined

  • Last visited

MinnesotaHam's Achievements


Rookie (2/14)

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

Recent Badges



  1. I found the answer in an old post here. Create another relationship. Use global key fields in both main and related. Then same sum calc field always finds all records regardless of found set in main table. Concern about update speed noted and appreciated. DB currently has 309 records in main and <600 in related. Main will never exceed 500 and related never exceed 2000. Even this will take years.
  2. Main table is types of vacuum tubes. Related table is ownership of various brands and shapes for each tube type, with a quantity field. Related table has summary field that calcs total of the Quantity field. This total changes as found set in main table changes. Primary layout has records of main table, with portal for related table. On this layout, how can I show total of Quantity field, for all records in main table, even if found set is less than all records ?
  3. Epilogue. After trial and error for days, I have working solution. Perhaps not as refined as expert coders, but it's reliable and useful. As suggested, I combined multiple files into one and use separate tables instead. The main table is a collection of types of tubes. The child table is ownership of individual tubes within each type. As I use an individual tube, I wanted to: 1-note where it went 2-remove from ownership 3-move it to archive, still linked to tube type. 4-simulataneously see ownership and archived tubes by tube type I was not able to elegantly achieve this with separate portals on a single page. My fault not Filemaker. I chose to move records from one child file to another child file for purpose of archive, then delete the original record. A traditional invoice/customer/line item solution did not fit my purpose. It was for this that I needed to understand Portal row status and Get commands. What tripped me up was not understanding that some calculation fields work only in conjunction with scripting. Thanks to all for the replies.
  4. In the Main file, Tube Name is the primary field. It is a group of different kinds of vacuum tubes. In the Listings file, it shows ownership of these kinds by Tube brand (and other details). As I use a tube one at a time for a repair, I've been reducing the Qty in the Listings to show I have one less available in my stock. What I wish to do is not just show a reduced Qty on hand, but to built a usage history as I reduce the on hand Qty. The usage history will show what radio they went in to, repair date, etc. The goal is to show on hand by kind (Tube Name) and also separately show usage by kind (Tube Name). There are approximately 300 kinds (Tube Names) with varying ownership for each. Prior to wanting a usage history, it was a single file with duplicate entries for kind (Tube Name). Tube name became a key field when I made the solution relational to achieve paragraph two. Some of the files are not necessary to the chief purpose of this database. Feature bloat. It's obvious now that I failed to understand the concept of Tables. I do now. I upgraded from 6 to 7 but didn't do much new design work till lately. What is good method to achieve goal in paragraph two ? Lookups ? Portal with match field for On Hand and another portal with match field for Usage History ?
  5. Here are two attachments. One is an archive of the files I'm using for my solution. You can ignore all scripts in the "...Listings" file. This file is a clone of the main file where all the scripts came from. The other file is a test file where I could not make some specific Get calcs work. Forgive my lack of courtesy by not attaching sooner. Was thinking I only needed help with specific calcs not guidance on overall design. I was wrong. Dale Saukerson Thanks. TestGet.fp7.zip VacuumTubeDatabase.zip
  6. I understood but didn't believe....thus iterated some details. I'm now doing what I should have done sooner: dig out the manual and peruse the help files more. It's apparent my design needs to change to better use the table concept. But now it has me wanting to see examples of how folks would use these two Get commands in a functioning solution. Thanks for your patience. It is appreciated.
  7. I have them unstored but tried stored as well. I also choose results correctly as appropriate (text/number etc). I mention moving the cursor around to different fields and repeating row to guarantee that a one of them has focus and the calculation field will report something. Example one, I have three fields. Text field named Type, repeating field named Brand, and calculation field defined as GetActiveFieldName. I have all threee fields on a single layout. I'm expecting the calc field to return the name of the field with focus, and to dynamically update if I move the cursor around. Example two, same as above only the calc field is defined as GetActiveFieldContents. I expect the calc field to return the contents of the field with focus and dynamically update if I move the cursor around. Is my use of the Get command in a calc field in this manner, faulty ? I hesitate to "send" a file not knowing how many will receive it. I did this a loooong time ago in a reply on a mailing list and they were not happy ;)
  8. I do have fields, populated with data. And I do move the cursor around as well. Still can't make it work. I know it's something basic.... The intent is to archive some records by moving from one related file to another related file. I was trying to do this without exporting and importing since I though it would be easier. Regardless, I still need to know what I'm doing wrong with the Get commands. The parent file is types of vacuum tubes. The child file is ownership listings of each type. Example, for type 6X5 tube I may own fifteen different boxed tubes. As I use one of the fifteen for a repair, I want to move it from ownership file to an archive file for a usage history. I'm fairly comfortable with calculations and syntax, but the majority of my previous experience was with flat files (and Status fields) and I'm stymied by failure to get some of the Get commands to report as expected. I'm been using simple example files to try and solve my problem to no avail. I could certainly send them on but might be better to send something my way instead ? I've looked thru the templates and example files and help files provided with the application.
  9. Not quite a newbie, but have more experience with Version 6 and earlier. I'm able to use portals and relationships OK. Somewhat confused on tables but think I'm OK on this. I have trouble with Get function for calculation fields. I can make broad ones work such as Get Filename, Get Application Version, etc. Some that I can't make work are centered around fields, portals and repeating fields. I suspect my problem is a gap in my basic knowledge of V7. Below are results for my calculations. Hopefully you can spot a pattern and give me a clue. The test file (parent) is simple. A single relationship, single table, single portal, single repeating field, and a single calculation field. Yes, I am setting the calculation results properly to text or number as required for the calculation. GetActiveFieldname always returns blank results GetActiveFieldContents always returns blank results GetActiveRepetitionNumber always returns 0 (zero) GetPortalRowNumber always returns 0 (zero) Any clue what I'm doing wrong ?
  10. The order in which they are recorded does not matter.
  11. I need to search for 4-8 items that will appear in 4-8 fields, but may appear in any order. Some of the items may be repeats of each other, or they may be unique. The DB is a flat file listing of the vacuum tubes used in antique radios. The DB has a field for the count of tubes, then eight fields for the tube names used. If it is a 4 tube radio, the tube count field will have an entry of 4, then only the first four tube fields will be filled in with data for the tube names. The tube names are alphanumeric but for simplicity I'll use numerals only. Example. I have a five tube radio using these tubes: 47, 47, 49, 50, 51. I want to find only entries that have five tubes, having these tube names , but they can appear in any order. I want to search the DB with example records shown below. Using above search criteria, it should find three records. Example records Tube count, tubename1, tubename2, tubename3, tubename4 5, 47, 47, 49, 50, 51 5, 49, 50, 51, 47, 47 5, 47, 49, 47, 50, 51 5, 46, 47, 49, 50, 51 6, 47, 47, 49, 50, 51, 51 Right now, I'm doing searches and sorts to find entries and narrow them down to a list that matches my criteria. My DB is flat but I have some experience with going relational. The DB currently has 5000 plus entries. How can I do this more efficiently?
  • Create New...

Important Information

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