FM10 - Perform lookup on unrelated database
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?