Jump to content

Matt Leach

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Matt Leach

  • Rank
  • Birthday 03/16/1984

Profile Information

  • Gender
  • Location
    Spring Hill, FL

Contact Methods

  • MSN
  1. I understand why given that example. Im going to have to get more information from them to get a better idea of how they come up with the batch numbers, etc..
  2. That's pretty much the same idea. As far as why that table contains the BatchID, i do not know as this was in place before i started working on the project. The basic purpose of the layout is to compare, for a particular ingredient with a specific batch number, how many kgs were delivered vs. how many kgs were used in production
  3. It is a follow up of that thread but i figured since it was more of a relationship question i would post it here. There is a table called Goods_In which represents a shipment that was received. The shipment details get entered into this table, and each ingredient that is included in the shipment is entered as a line item into the Goods_In_Ingredient table.
  4. Im working on a recipe database and am coming up on the last phase of the project and am drawing a blank on how to accommodate the request. I need a layout to compare information from 2 tables. The tables are: 1. Goods_In_Ingredients 2. Production_Ingredients. Im not sure how to setup a relationship for this scenario or if it is even possible. Here is a bit of details outlining what i'm trying to do. I need to have 2 drops down lists on the layout. One for "Ingredients" and one for "Batch_Code". Based on what is selected from these drop downs, the following needs to
  5. Are you referring to this tread? http://fmforums.com/...evious-records/ --- Disregard, i found the sample file
  6. After reading through the forum you mentioned and playing around a bit, i think i'm about 90% there. I've setup the following script: Set Variable [$ProdID; Value:ProductionRecords::pk_Production_ID] Freeze Window GTRR [From table; "Recipe_LineItems"; Using layout: "Recipe_LineItems" (Recipe_LineItems)] Go To Record / Request / Page [First] Loop Set Variable [$Ingredient; Value:Recipe_LineItem::Ingredient_Name] Set Variable [$Amt; Value:Recipe_LineItem::Amount] Go To Layou ["Production_LineItem" (Production_LineITem)] New Record / Request Set Field [Production_LineItem:
  7. I will go through the post you referenced as it appears to be the same thing i am attempting to do. Thanks again, you're always very helpful and i appreciate it.
  8. Ive done some searches on copying records across tables but have been unable to do so successfully. Im working on a recipe database that has a few tables that are related: Recipes Recipe_LineItem ProductionRecords Production_LineItem My relationship is as follows: Recipe_LineItem --> Recipe <-- ProductionRecords <-- Production_LineItem A bit of information on the setup: The Recipe layout contains a field for recipe name and a portal to Recipe_LineItem. Each Recipe_LineItem is an ingredient for that recipe. The ProductionRecords database
  9. Unfortunately at this point it doesnt matter because they now want to go another direction on this layout. Thank you all for your input as it will help in future projects.
  10. Disregard. I took a look at it again this morning with a fresh mind and realized the Recipe_ID in the production record was not getting enetered which is why the portal was still empty. Thanks for your assistance.
  11. I've made sure that my relationships were set correctly and they match what you have provided above. My portal is set to show Related records from Recipe_LineItems when i click the drop down to select the recipe, the portal remains empty. Could the issue be that all 3 tables are related using the Recipe_ID field?
  12. I've recently started working on a database that was started by someone else but never finished so i'm trying to finish it. The database has one to many relationships and i am trying to setup a filtered portal based on a field and am having a little bit of difficulty. So far there are 3 tables involved all of which are linked by a field called recipe_id: Recipes Recipe_LineItems Production On the Recipe table / layout i have a recipe name field there is a portal that is linked to Recipe_LineItem table which allows the user to enter each ingredient for that recipe.
  13. I wish that were the case, i only have about 2 or 3 schedules setup on the server and they are all daily schedules. I've even deleted all schedules and re-entered and there is no change. I think at this point I only have 2 more options to try: 1. Change the time zone to pacific and then back to eastern to see if the server then works off the correct time zone. 2. Reinstall FMS. I hate having to do this especially since it's a 2 server deployment but may be my only option.
  14. I'm currently running FMSA11 and have a few server side scripts on a schedule. I attempted to setup a new schedule today and am having an issue with the Start / End times. The parameters i would like to setup are: Server side script to run daily every 15 minutes Start Time: 9:00AM End Time: 10:00PM When i attempt this time range, FileMaker states that the End Time needs to be after the Start time which it clearly is. For the mean time i compromised and set the End Time to 8:00PM and File Maker accepted that. When i save the changes and view the details for the schedule at th
  • Create New...

Important Information

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