Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Customer Drop Downs


Recommended Posts

In FM 8.5, I have one table, Customer with the fields Name, Company, Email Address. Quotes are in a second table named Order. One company can have several Names, and emails.


I would like when a new quote is started there are drop downs of the related names and emails based upon the company name. I have it where the company shows up in the new quote, but cannont make the drop downs work.


Guidance would be appreciated.



Link to comment
Share on other sites

Okay the layout context you are on (by the sounds of it, it is Order), you are setting a company name into a field on the order.


You need to create a relationship from the context (Order) to the Customers table, the predicates of the relationship are from your Company field (on the Quote) to the Company field on the Customers table.


Now setup a value list using the related values option. Choose the fields you wish to use in the value list as per usual (making sure you are choosing from the new relationship to cusotmers you created) ie you might choose record ID & name, or just customer name, or however you wish to link a customer to an order.


Check the option "use related values starting from:" and choose your original context (Quote).


Now when you choose a company on the quote, it establishes a relationship to all customers who have the same company. YOu can now set this value list onto the field you want on the quote (ie Customer contact...)


Hope this works for you.

Link to comment
Share on other sites

Okay, I can get that relationship and drop down to work. This however, makes another script not work.


I have a script New Order for Customer,

Go to Layout Order

Enter Browse

New Record Request

Set Field (Order::_KF_CustomerID; Get (Script Parameter)


End of Script


I have the relationship at Customer::Company = Order::Company.


Script Paramenter is Customer::__KP_CustomerID


I cannot get Company to fill for Customer Table, If I type is in the name and email drop downs work.


If I change the relationship to Customer::__Kp_CustomerID = Order::__Kf_CustomerID, the drop downs will not work.

Link to comment
Share on other sites

1. Add a Commit record script step at the end of your script

2. Change the company field on your order to an auto-enter calculation, and have it auto enter to Customer::Company.


The last relationship you specified Customer::__Kp_CustomerID = Order::__Kf_CustomerID is not going to work because it is not based on what you want to see (customers of same company).


Since your relationship should be from Order::Company to Customer::Company you need to have Order::Company populated - hopefully the auto enter will solve this issue for you.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use