AnsweredAssumed Answered

Layout Design : Creating Records in Related Tables

Question asked by chawks1995 on Oct 12, 2009
Latest reply on Oct 12, 2009 by chawks1995

Title

Layout Design : Creating Records in Related Tables

Post

Hello,

 

I have created a simple database that consists of (2) Tables - Customers and Orders. These two tables are linked via a "Customer Number" field. What I would like to do is create a layout that has two panes - the left pane would show customer information and have a button to add new customers. The right pane would show the currently selected customer's orders - only one at a time (like a page) and have a button to add an additional order.

 

The problem that I am encountering is that the form is based on the "Customers" table so anytime you click a button to add a new "order" it creates a blank record in the customer table. The question is: "How do you design a layout that is based on customers table that will allow you to add multiple entries in the orders table?

 

I would prefer not to use a portal on the layout for orders and would like instead to have a single order shown with buttons to advance forward or back in the order history.

 

A big thanks in advance for any assistance!

 

chawks1995:manwink: 

FileMaker 10 : OS X V5

Outcomes