AnsweredAssumed Answered

FM10 - Perform lookup on unrelated database

Question asked by donjuancarlos_1 on Apr 8, 2009
Latest reply on Apr 16, 2009 by donjuancarlos_1

Title

FM10 - Perform lookup on unrelated database

Post

Hi all,

 

This is my first post here. :)

 

I am creating a database to allow my company's quoting department to perform quotes in FM10.

 

I have created dropdown menus for each quote line and populated them with value lists from my unrelated inventory file.  For example:

 

Inventory item                                                     Unit Price                Quantity               Total

 

[dropdown list showing door types]                    $x.xx

[dropdown list showing window types]

[dropdown list showingdoor hardware types]

.

.

.

 

When I select a door type from the dropdown list, I probably need some sort of script trigger to go to the inventory database and find the associated unit price and automatically enter it in the Unit Price box. Does anyone know how I would do this?

Outcomes