Relationship with defined fields

[bckwheat]

I have built a DB with multiple fields. Three of which have a relationship. Company, company code, company type. If I click on company, the pop up menu shows my list of companies and I select the one I want and it files in the relationship for that company (company code, and type). All works well. The problem is if I go to the pop up menu for Company type after I have selected the company and select a different company type it shows my new selection but when I go to simple list layout of my companies that reference all my fields for the companies, the company type (in the list layout) is the original company code that was entered when I selected the company. If I go back to that record in the original layout my new company code is there but returning to the list layout it still has the original selection. I can (in the list layout) select the pop up for the company type and select the new one and it stays. I have checked the pop-menu and it has the check box selected to "allow entry". ANY IDEAS?:??

PM.zip

[Ugo DI LUCA]

May be I didn't understand what you were trying to do, but all seems to work for me. When you select the popup in Press Monkey Layout 1, and change it, the change are made in the customer data in either list layout and layout 1 for this file.

I even tried modifying the press type in customer data and all worked.

This is logical as you set the press type in Press Monkey as "::Customer Data:press type".

There is a point I didn't understand. Why should the press type for customer be changed when in Press Monkey ? Why not set the field as a lookup from the Customer Data ?

Please explain ? Maybe I didn't figured out what was your problem.

But...just check the relationship Customerdata in the menu and set it to allow creation of related records, and you could modify the press type even in Press Monkey.

[bckwheat]

The reason is that a customers job is printed on whatever press that is in customer data. On occasion the switch which press to send it to and thus the issue.

When I select a customer and change the press type, then I go the "view list by PR/Customer" layout, over on the right of screen the press type is set to what was in the original customer data for that customer. I can change it there and it stays. If I don't change in this layout and go back to the original "new label" layout the press type is once again what I changed it to.

Weird

[Ugo DI LUCA]

OK, just check your file again.

The list from layout 1 and list by Pr aren't the same; One is related to customer, the other is not...

[bckwheat]

I guess I don't understand. Both layout 1 and list by pr are using the same records. Layout 1 show's one record at a time, "list by PR" shows all of them. How can the different layouts with the same records not show the same data?

I thank you for your interest and continued help

Bruce

[Ugo DI LUCA]

They both use the same value list, but your fields are different :

In list mode, press is an entry of the field "Press type" from your Main file (Press Monkey)

In Layout, press is an entry of field "Press type" from your Related file (Customer Data).

In your set field options in Press Monkey, "Press Type" is a look up from customer data. Your relationship is Press Monkey:Customer Name::Customer data:Customer Name. Then, and this is a principle of a lookup, you have to tell FM to reset the relationship everytime a field changed in customer data to have it change in Monkey.

Try this to show how it works :

When selected the new type from pop up list in Layout 1, exit the field and come back to Customer Name. Select the same customer from your popup list. This is it. FM just looked back to Customer Data to update Monkey.

Do you get it ?