Dynamic Layouts & Value Lists

[mvhurlburt]

Hello all I am fairly new to FMP and am at a beginners, conceptually alot of it isn't too difficult as I am familiar with Obj-C, C, some java, etc so I get some of the underlying concepts. Essentially what I have done so far is created a database for the window and door company I work for. What it presently does is store the prospects name, address, phone numbers, email, the product demoed, high price, low price, demo outcome, where the lead came from, a number of image containers to upload purchase agreements and various other docs into. It generates and emails reports and various other things. It works great for this but I would like to add an additional layout that I can generate a work order for the factory with. The idea will be to add a button in the main layout to add a work order, the new layout will display the clients name and other information in a header along with an auto-generated work order #. What I would like to do is have a number of contextual menus below. The first being the series of the window but I would like the data that populates the model list to be based on the series selected and so on and so forth. I know there is some pretty good stuff here on dynamic value lists but alot of it is still a bit over my head so if anyone could point me to a good article for beginners or a sample layout that would be great. Ok so thats problem number 1, heres number 2. The layout will look as follows:

Header with name Auto-generated WO #

address

Phone number

___________________________________________________________

Contextual menus: Series, Model, Glass Pack, Grids, Color

Check Boxes: Tempered Glass, Double Strength, etc

Text Fields: Width, Height, Quantity, etc

ok so you can now picture the layout but since the quantities, series and models all vary from job to job I was wondering if there was a way that by default it will just display one row of the above menus, boxes, etc and with the use of an "Add" button I could add additional rows? If so if anyone knows of a good starting point for that sort of thing it would be very helpful. If not perhaps there is an alternative approach that I could utilize with a relational database where I simply added a new record for each item and could have them displayed in a list view of sorts?

Thanks,

Mike

[comment]

See if this can get you started:

PortalCondVL.zip