Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About emballantine

  • Rank
  • Birthday September 23

Profile Information

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

Recent Profile Visitors

1,157 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. 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 t
  5. 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. Afte
  6. 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.
  7. 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 Ite
  8. 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.
  9. 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 glo
  10. 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?
  11. 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,
  12. 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
  13. 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
  • Create New...

Important Information

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