AnsweredAssumed Answered

Creating very simple relation

Question asked by stasca on May 1, 2009
Latest reply on May 1, 2009 by philmodjunk


Creating very simple relation


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