Jump to content

emballantine

Members
  • Content count

    26
  • Joined

  • Last visited

Community Reputation

0 Neutral

About emballantine

  • Rank
    member
  • Birthday September 23

Profile Information

  • Title
    Filemaker Solution Design/Maintenance
  • Industry
    Entertainment
  • Gender
    Female
  • Location
    New York, NY
  • Interests
    Database design, web design, scripting, audio/video engineering

Recent Profile Visitors

765 profile views
  1. Has this forum topic moved? I can's seem to access this address? Thanks!
  2. emballantine

    Label Help

    Has this moved? When I try to go to this address it says this page cannot be found. Thanks!
  3. I've been looking around to try to find this info: When in the process does a field that is set to Auto Enter: Creation Timestamp actually enter the data? On creation? On commit? Is it the same for all creation and modification auto entry? Thanks!
  4. emballantine

    Filtering Many to Many relationships

    It is very helpful in explaining what you were talking about earlier with the separate join table. But....my problem is that I have an Asset Table. I have three different assets that are all Apple Alphas and two different assets that are Bravos. Is there a way, through relationships, additional fields, or something else entirely that I am not aware of, to create a layout based on the Assets Table that allows a user entering inventory to choose a Product from a dropdown list that has been filtered by category and manufacturer? Ie. The asset layout allows me to select a category and then a manufacturer (preferably only manufacturers that produce products in the previously selected category (like your example), and then a product that is made by said manufacturer in said category. (In my database the product list will be quite extensive (we have a ton of thing-a-ma-bobs, whozits, and whatzits) and I would like to be able to whittle that dropdown list by category and then manufacturer - manufacturer list will, also, be quite extensive.) Even more awesome would be if there was a way to populate all these fields if necessary. Ie. I have a new asset which is a new item in a new category made by a new manufacturer and want to be able to input all the information from the same layout and have it propagate all the appropriate fields in all the tables and relate them accordingly. I'm sorry if this explanation is confusing. I am trying to simplify it as much as possible, but I imagine I am asking to do a complicated thing.
  5. emballantine

    Filtering Many to Many relationships

    Which part doesn't make sense?
  6. emballantine

    Filtering Many to Many relationships

    I'm sorry if I've been unclear. Maybe my terminology is wrong. I'm not asking how to populate those two fields (Assets::CategoryID_fk and Assets::ManufacturerID_fk). Pretend those fields don't exist in the assets table. I get what your saying on that. I want to be able to populate the following fields from a layout based on the assets table. Assets::AssetID_pk, Items::CategoryID_fk, Items::ManufacturerID_fk, and Assets::ItemID_fk. 1. Assets::AssetID_pk is an autopopulated serial number. 2. I have a dropdown list of Categories to enter the Items::CategoryID_fk field. 3. After choosing a category to populate the Items::CategoryID_fk field, I want the drop down list for entering the Items::ManufacturerID_fk field to be constrained to only manufacturers who make items in the category chosen previously. 4. Then after choosing both a category and a manufacturer, I want the drop down list for entering the Assets::ItemID_fk field to be constrained to only items in the chosen category made by the chosen manufacturer. Is this scenario possible? Using your example...I have created a small example file with the Manufacturer, Category, and Item Tables populated. I have set up the Asset Layout, but do not how to do the filtering necessary to achieve the effect described above. So, at the moment each drop down for data entry from the Asset Layout just shows all of the Categories and all of the Manufacturers in the database. I have not populated the Asset table with any data yet. Example1.fmp12
  7. emballantine

    Filtering Many to Many relationships

    Yes, the CategoryID_fk and ManufacturerID_fk fields in the assets table are redundant. I am using them to create the relationship between assets and items that allows me to filter an ItemID dropdown by manufacturer and category on the assets layout. If there's some better way to do that, I would love to learn. Really, though....my question is about the many to many portion of the problem. How to filter a dropdown list of manufacturers by categories that they are related to through the items table? Thanks.
  8. Okay, I am working on an Inventory Solution. Right now I am just focusing on the Data Entry end. I have the following tables and relationships: Assets Table AssetID_Pk ItemID_Fk ManufacturerID_Fk CategoryID_FK Item Table ItemID_Pk ManufacturerID_Fk CategoryID_Fk Manufacturer Table ManufactuereID_Pk Category Table CategoryID_Pk Each AssetID can only relate to one ItemID, but one ItemID can relate to multiple AssetIDs Each ItemID can only relate to one ManufacturerID, but one ManufacturerID can relate to multiple ItemIDs Each ItemID can only relate to one CategoryID, but one CategoryID can relate to multiple ItemIDs Each Category can relate to many Manufacturers (through the Item Table), and each Manufacturer can relate to many Categories (through the Item Table) I would like to have a data entry layout (based on the Assets Table) where first you choose a Category from a dropdown list of categories Next you choose a Manufacturer from a dropdown list that has been filtered to only show Manufacturers who manufacturer items in the category chosen in step 1. Is this possible given the many to many relationship of Manufacturer and Category through the Item table.? Next you choose an Item from a dropdown that has been filtered by both Manufacturer and Category. I think I know how to do this, I have an instance of the Item Table with a relationship between it and the Asset Table that relates both the CategoryID_kf and the ManufacturerID_kf in each table that I use to create a Value List that is filtered via this relationship. Is there a way to do this? Thanks!
  9. emballantine

    Labels - Laying them out

    I have been searching all over the filemaker world for better info on how to adjust layouts for label printing. I want to print to a label sheet that is not Avery. It is 9 columns wide, but each column of labels (.75") has a small space between them. I can't find a way to put that space in the layout to make sure the labels align.
  10. emballantine

    Counting Records of a Certain Type?

    Thanks! That actually clears that up a lot.
  11. emballantine

    Counting Records of a Certain Type?

    Also, can anyone describe to me the different uses of a global field vs a global variable? benefits of one over another? example of when one might be more or less appropriate? For instance: If I have the portal that I have been working on in the Inventory layout Tracking tab and want to use the location Y from one portal row as a filter for another portal on Inventory tab that will list all the assets of the item type X in Location Y, does it matter if I pass this location information to the filter via a variable or a global field? Do they act differently? Right now I am doing it with a global variable $$CurrentLocation, and that works. I'm just curious if it would be better to do it with a global field instead. If using a global field to just hold what is essentially a variable - how do you determine the most appropriate table to place the global field in? For instance if I wanted to create a field gCurrentLocation instead of variable $$CurrentLocation what table should gCurrentLocation reside in? *I think the hardest part of FileMaker for me is that my OCD wants there to be one right way to do each thing and I realize that is not how FileMaker is designed to work. STCSVCInventory20150701.fmp12
  12. emballantine

    Counting Records of a Certain Type?

    Thanks! I knew it had to be something small but significant that I had missed. Having it be unstored means it has to recalculate every time? as opposed to when it was storing it...it was just storing it at the time of data entry? Is this accurate?
  13. emballantine

    Counting Records of a Certain Type?

    Okay, eos. I checked out your file. I tried to deconstruct it and apply it to my larger solution. It is not quite working the same in my larger solution as it is in the example you modified. I'm going to reattach the file you sent (which I added a little to), and my larger file. The larger file has the same basic setup (at least the part I am dealing with right now). There is an InventoryItems table, an Assets table, and a Locations_current table, as well as the added occurrence of the Assets table Assets_forLocationAndSelectedItem. I thought I set up this the same is it is in the example, bit I am getting slightly different results. In the example you sent it does exactly what I wanted it to, gives a count for an item by location. In the larger solution it seems to be counting each entry of an item. In other words the first asset of item X has a cFoundCount of 1, the next has a cFoundCount of 2, etc. and the first asset of item Y has a cFoundCount of 1, the next 2, etc. So, the Portal that displays the locations and cFoundCount displays the first cFoundCount for that item in that location. In other words, on a record for item X in the portal displays the location and then the cFoundCount of the first asset record in that location. I have checked all my relationships, my fields, and my script....and they all seem right as per your example. I can't figure out why the difference in result, but I am sure it's something small or simple that I am missing. Maybe it will be more obvious to you? The Layout is called Inventory and the tab with the Portal is called Tracking. Thanks! STCSVCInventory20150701.fmp12 AssetInventoryLocation_eosMOD.fmp12
  14. emballantine

    Counting Records of a Certain Type?

    I have tried the Count function. It gets me part way there. Very helpful, but not quite there. Here is a more thorough explanation of what I want to do: This is my end goal. I have a table of InventoryItems that contain Make and Model information about items we own. One ItemID for each type of item. I have a second table (child) called Assets that contains information to each specific Asset including AssetID. So.....an InventoryItem might have the ItemID of 001 and be an Apple Mac Pro. An Asset might be Apple Mac Pro 1 with AssetID of 001, Apple Mac Pro 2 with AssetID 002, and Apple Mac Pro 3 with AssetID 003. I, also have a table of Locations with a LocationID for each location. So, a LocationID might be RackRoom1, or RackRoom2. RackRoom1 may contain AssetIDs 001 and 002. RackRoom2 may contain AssetID 003. I want to be able to display all the Item information of Apple Mac Pro in a layout. These are things like Manufacturer, Model Name, etc. What I want to do next is display (on the same layout, though probably on a different tab) Items by Location. So....a portal where each line shows a name (ID) of the location and a count of the number of Assets that are of the Item type Apple Mac Pro. In this case one portal row would have location RackRoom1 qty 2, and the next would have RackRoom2 qty 1. And then.....I would love to have a button to click in each portal row that would list the assets in that location. Can this be done? Can this be done on one layout? Am I correct starting the layout from the InventoryItems table? Or should it start from a different table? I am attaching a simpler version of the larger solution I am working on, the Layout I am working from is called InventoryItems. Right now it shows a record for a specific Item. Great. There is a portal based on the Locations table that displays LocationID and a calculated field from the Location table (Count(_pkAssetID)) that is counting the number of assets in each location. What I want, though, is for it to count the number of assets of the type of Item the rest of the layout is referencing. Ie. layout InventoryItems is showing info for an Apple Mac Pro. The portal is displaying all the locations where there is an Apple Mac Pro, but the count field from the Locations table is calculating all the assets in that location instead of just the Apple Mac Pro in that location. I need some way to filter the assets in a location by item type and then count them. I just don't know if this would be done in a table or in the layout or a script of some sort. Thank you kindly! AssetInventoryLocation.fmp12
  15. What is the best way to count records of a certain type in a table? For instance I have a table of Categories, primary key field pkCategoryName and a table of Items primary key field pkItemID. The two tables are related (one to many) via a foreign key field fkItemCategoryName (many) in the Items table that correlates with pkCategoryName (one) in the Categories table. I want to count the number of ItemID records that have fkItemCategoryName "X". I know this has to be something fairly simple, perhaps too simple.....but I haven't found a good way to do this. Thanks! ExtraCredit: This is my end goal. I have a table of InventoryItems that contain Make and Model information about items we own. One ItemID for each type of item. I have a second table (child) called Assets that contains information to each specific Asset including AssetID. So.....an InventoryItem might have the ItemID of 001 and be an Apple Mac Pro. An Asset might be Apple Mac Pro 1 with AssetID of 001, Apple Mac Pro 2 with AssetID 002, and Apple Mac Pro 3 with AssetID 003. I, also have a table of Locations with a LocationID for each location. So, a LocationID might be RackRoom1, or RackRoom2. RackRoom1 may contain AssetIDs 001 and 002. RackRoom2 may contain AssetID 003. I want to be able to display all the Item information of Apple Mac Pro in a layout. These are things like Manufacturer, Model Name, etc. What I want to do next is display (on the same layout, though probably on a different tab) Items by Location. So....a portal where each line shows a name (ID) of the location and a count of the number of Assets that are of the Item type Apple Mac Pro. In this case one portal row would have location RackRoom1 qty 2, and the next would have RackRoom2 qty 1. And then.....I would love to have a button to click in each portal row that would list the assets in that location. Can this be done? Can this be done on one layout? Am I correct starting the layout from the InventoryItems table? Or should it start from a different table?
×

Important Information

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