Value list with parts selection, related pricing.

[Ken Steiger]

Hi.I am a newbie so please bear with me. Using FMP 7 I want to create a billing layout for CABLE REPAIRS. Each record contains fields relating to the company, cable type, employee/technician, hrs billed, rate, etc... It also includes an area that calculates the charges incurred when replacing commonly used connectors and materials on these items. I have 4 groups of fields. Each group has a "Qty" field next to a "Connectors" field. Each field in these groups is a separate occurrence.

The "connectors" fields are named "A" "B" "C" and "D". I want each these to utilize a drop down value list to select one of the connector types. (Probably 20 types) The user can choose to select quantities of connectors from one or all of these groups of fields via their individual value lists. I also want to be able to assign a price to each of these 20 items in each value list so that a calculation can be made when selecting "Qty" (2) times the "Connector" ("3 pin XLR" which is billed at $4.00) Each of these fields would be considered in the calculation plus another field that contains the miscellaneous charges enetered directly by the user. A summary field could give the total with taxes etc. at the end of the layout.

My problem is that so far I have not even been able to get the "Connectors" field to display the different types when the value list is composed of the "use values from fields" option.

I am also trying to figure out how to have this data remove the connectors from stock in a related inventory table. At some point we will want to have a WORK ORDER layout as well for new jobs.

If somebody gets what I am trying to do and can explain it to me, I would really appreciate the help. Many Thanks

Ken Steiger