Related Record Based on Any Change

[abridges]

I have the following situation, and it has probably been answered here several times, but I haven't been able to find a solution.

I am trying to related a master file to a contact file where someone entering in data can pick from conditional popups, and add new items if needed.

Say,

Customer Name

Customer Contact (multiple per customer)

Product (multiple per customer and mulipule per contact)

Product Division (again, per customer/contact and product)

The trick is, I want to pick a customer and see only contacts for that customer, then pick a contact and see only products for that contact, then pick a product and pick from only products for that product. But, if any one of the above changes I want that to be added to the list not changed.

Example

Customer A through Z,

Choose A

Shows Contacts for A - John, Sara, Bill

Choose Sara

Shows Products for Sara - Box, Tray, Tube.

Choose Tube

Shows Divisions for Tube - 1,2,3

Add Division 4

New Record is Created with Following info

Customer A, Contact Sara, Product Tube, Division 4

It could just have well been customer, contact or product that was not in the list.

Hope someone can help, would prefer not to use scripts to fix this situation.

Thanks,

Andrew

[LiveOak]

You should be able to do what you wish using a value list based upon a relationship. The first relationship is with Contacts based upon Customer No., the second is with Products based Contact No., the third is with Product Division based upon Product No.

To "add" to a related list, you will need to change one side or the other of a relationship or add a record to the related database.To create a new record, you will need to use either a script or three portals instead of drop down lists. With a portal, you can add a records to the list by clicking on the blank line (if the relationship is set to allow the creation of related records).

-bd