AnsweredAssumed Answered

How to narrow selection on one field based on selection of another.

Question asked by beauvinciviolins on Aug 20, 2012
Latest reply on Aug 22, 2012 by philmodjunk

Title

How to narrow selection on one field based on selection of another.

Post

I'm a complete rookie so please excuse this very basic question.

I'm using FMP12.  I'm trying to create an invoiceing system.  I have the basic concept of using a line item table, an inventory table and an invoice table with unique serial numbers and relating them via primary and foriegn keys.

I would like to have drop down and pop up menus when creating an invoice that narrows down your selections as you fill out the form.

Ex: Field#1= Product (Violin,bow,rosin,etc)  

Field#2=Brand limited to first selection (if you selected rosin in the 1st field, only the 10 brands of rosin would appear in the pop-up menu of the 2nd field to choose from)

Field#3=Item Details (color, size, etc. based on available choices of the 2nd field.)

After making these selections, they will result in a new line item on the invoice.

Each selection is an attribute of an inventory item, so I would like to avoid creating new tables for different attributes.

What would be the best way to approach this goal?

Outcomes