DavidT

Hi, This is my first post and I'm pulling my hair out on this one! I have a db with 2 tables. one is a recipes table with fields for ingredient 1...ingredient cost, ingredient 2...ingredient cost, etc etc. There are fields for 10 ingredients. The 2nd table details all the ingredients and their costs and other attributes. I want the db, when a user types in the ingredient in 'ingredient 1', to look up the cost for that ingredient and display it in ingredient 1 cost. Then do the same thing for each ingredient. Maybe I'm going completely the wrong way about the structure, but I've tried making a relationship between the 2 tables with each ingredient in the recipes table to the single ingredient id field in the ingredients table. It works when I just have ingredient1 linked, but when I link the other ingredients, it all falls over. I'm trying to teach myself how to do it, but I'm lost now! Any help appreciated

Thanks Ender, Yes you got the gist of what I need to do. I'll try it. Many Thanks David

Hi, We are developing a system using FM to record quality management systems for our business. We have created unique batch numbers, within which each item has its own number code. The batch id has 2 fields which identify the lowest and highest individual item number respectively. On another layout, we use the item number to assess characteristics of that item, but we want to automate the other fields which relate to the parent batch. For example. Batch 001 has item codes 1000 to 2000. The batch was created on 11/04/04 and originally came from site A. This is in Layout called Intake QC. On Analysis QC layout we want to input item ID 1500 and have the details of date and source come up automatically. Any ideas how this can be done? Thanks FileMaker Version: 5 Platform: Windows XP