Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About JD2775

  • Rank

Profile Information

  • Gender
    Not Telling
  1. Hi, I don't want to bog down this thread anymore than I have...if you get a second can you shoot me an email? jdenault00 AT yahoo.com. I can't figure this out. If you are too busy don't worry about it. Thanks man
  2. I hate to keep bugging you with this, but I am having a hard time figuring out the Reporting and sub-summary. I created a new field in the Transactions Table called "Summary", type-Summary-TotalCount. I created a blank report based off the Transactions Records. I set it up as a List View Report. I inserted all the appropriate fields into the Body, then adding a "Trailing Grand Summary" at the bottom. That is only thing that works, it totals everything. When I add a sub-summary part in between, it either shows the Grand Summary again, or no data at all. Ive got my "Missing Manual" in
  3. Ahhhh ok, it just clicked. You enter the Warehouse once in the Warehouse table, associated with a Wing. The data entry table shows ALL the warehouses at the same time. The only data you are actually entering is the quantity for Type 1 and Type 2. Now it makes sense. When I said pop-up, I didnt visualize all the warehouses already being shown in a table view, or narrowed down by a "Find". Your way is more efficient.
  4. Ahhh ok. That makes sense. Ok one more question... I want to pre-load all the Warehouse Wings and Warehouses into a table. Do I need a new table for this? The reason being is in the Data Entry table I want to have a pop-up custom value list of the Wings, and then I want a pop-up list of Warehouses that are related to that wing. That way you don't choose from a value list of 60+ Warehouses, more like 7-8. (this was the part i was screwing up with before, having a different layout for each wing) Thanks
  5. Hey, Thanks so much for putting that together. I was able to replicate this and figure out how it works. Makes perfect sense to duplicate the tables in the graph, link it as you have and use global fields. 2 questions: What is the dash '-' field for in the Warehouse table? I can't figure out it's use... and.. What would the calculations be, given your set-up to show totals for Type1 and Type2 per wing based off a certain date, and the grand total based off a certain date as well? Also, what table should these calculated fields reside in? Or should they be in a seperat
  6. Yep, that would be ideal. Behind the scenes I realize it would be 2 records, but how do I get around that in the data-entry layout? Do I have duplicated fields for Bulb Type and Number? Or? I'm trying to visualize it
  7. I guess nothing. They are unique. I just wanted a way to record both at the same time without hitting "new record" in between, hence my flawed set-up of fields "Metal Halide" and "High Pressure Sodium" to record both at once. It seems like that is not the right way to do it though, and they need to be unique records? Also, does my quote above make sense about adding another table with the fields Wing and Warehouse and relating that to the Data table? Thanks
  8. I think it could, I just need to lay it out differently. Change the radio-button to drop down menus for Warehouse field, something like that. Or better yet, have a drop-down for Wing, that activates a drop-down for Warehouse so your menu isnt too long to scroll down. One other question I had, you mentioned I should have a bulb type field, rather than have the 2 bulbs be their own "field". That makes sense, but how would I enter the data into ONE record? It seems to be I would have to do this: Warehouse= A1, Type =Metal Halide, Number_Out= 5 *new record* Warehouse=A1, Typ
  9. Hi guys, I have a pretty basic database that I need to add a summary report/layout to. The database tracks the number of light bulbs out in a warehouse, and will be used on an iPad. There are 10 "wings" of warehouses, A-I, with each wing having a certain number of warehouses within it. I have one table in the database, tbl_data_tracking, with the fields: Date Warehouse Metal Halide (type of bulb) High Pressure Sodium (type of bulb) I have 10 layouts (one for each wing) and 10 value lists of warehouses. For example the A Wing has 9 warehouses, so the "A Wing" value li
  10. Hi, I have a few checkbox fields in my layout that I want to export to Excel. The problem is when I do this I get some very weird results and strange characters. Is there a secret overall to exporting check-box value fields into Excel, where they are actually usable? i.e, look correct, can do calculations etc etc. One thing I did in Filemaker to get rid of the actual checkbox logos themselves in tableview was do a substitute field. Substitute(Field1; "¶"; ",") This stores the checked values with a comma between them in FMP, but I still dont get the correct results when exporting to Excel. Basi
  11. Thank you Comment. So it sounds like I need an additonal section table, tblSection linked to tblWarehouse? From there do the conditional value list based off tblIssues::Warehouse and tblSection::Warehouse? Or am I mixed up there
  12. Im sorry Doug, you are absolutely correct. I was mistaken as I just double checked. The locations are actually a value list, not a table, consisting of values of tbl_Warehouses::location just as you mentioned. A section would be populated based off the Warehouse/Issue that is checked. Warehouse 1/ Issue "Exhaust Fans" would have a related value list of Exhaust Fan 1, Exhaust Fan 2 to choose from. Warehouse 2/ "Exhaust Fans" would have 4 Exhaust Locations (bigger warehouse). Hence the need for Section to fill based off combination of Warehouse/Issue that the user selects. Currently
  13. Hi Doug, Location examples: CA, NV, AZ within each of those locations are a set list of Warehouses. CA Warehouse 1 Warehouse 2 Warehouse 3 NV Warehouse 4 Warehouse 5 Warehouse 6 The process is the following: The user records maintenance issues on a specific warehouse on an iPad (FM GO app). If the user chooses CA from the location, only the Warehouses associated with CA appear in the drop-down menu. From there you have set Issues associated with a Location. CA has issue1, issue2, issue3 NV has issue4, issue5, issue6.... The field I need added
  • Create New...

Important Information

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