AnsweredAssumed Answered

Entering Data fro m One Layout to Multiple Tables

Question asked by JackLogan on May 13, 2012
Latest reply on May 14, 2012 by GuyStevens

Title

Entering Data fro m One Layout to Multiple Tables

Post

Hi, I am very new to filemaker pro 11 and am having trouble figuring this out. Im sure its something simple and am hoping someone can help me out.

I basically have an inventory db with 4 tables as can be seen in the picture.

The relationship between the 4 tables is this

For Each Store(customer) I can have many Store SV Numbers(Invoice).

Each Store SV Number(Invoice) can have one or more Part NUmbers(Product). Which is why i made the Store SV Line Table(Join Table) as a Join table.

Instead of having multiple layouts for entering very little information. How do i add all the relevant data from the first 3 tables as a form for entering new records on the Inventory Layout screen.

Also, How do i get the foreign key of a child table to autopopulate with the primary key ID of a parent table based on a field common to both tables. For example,

If i have a product with a part number of 001554 and primary key of 1 assigned. How do i get the Join Table to automatically populate the primary key in the foreign key field by simply typing in the part number 001554 in the Child table.

PLease Help!

Relationship.JPG

Outcomes