1 Reply Latest reply on May 1, 2009 11:59 AM by philmodjunk

    Creating very simple relation

    stasca

      Title

      Creating very simple relation

      Post

      I'm trying to create database with 2 "tables".

       

       The first is basically a list of items on a short lunch menu.  It includes: Item #, item description and item price.

      The second is a customer check.  It includes: check number, a list of what the customer orders and calculates their bill .

       

      I want to be able to input the item# and have filemaker get the item description and price from the first table .

       

      I setup a relationship between the two tables.  I am able to pull in the first item but unable to pull in additional items.  I tried using a repeated field.

       

      Please help

       

      Scott

      5612-789-2678 

        • 1. Re: Creating very simple relation
          philmodjunk
            

          The standard approach is to create a third table "line items" where each item purchased is a separate record which you link to your "customer check" table. You can display these records in a portal on a layout that references your customer check table.

           

          You can look  up "creating portals to hold related records" in the on line help system for more information on portals.