Hello,

I have a layout with lots of columns. These columns need to be filled out using formula or manually. But one of the column (Item) is filled using value from the Item file. What I want to do is when I click on the column title I want to load a separate layout window with data from the Item file, on top of my current layout ( ie. pop-up window not a pop-up list). I then select x number of items from the pop-up window and click on an add button on the popup window. These items are then added to the Item column of the original layout. How can I do this? Can it be done in FM Pro?

I am using FM Pro 6 on Windows.

Thanks for any advice you can give.

Make the field a button, which opens the related file (with the appropriate values) when you click on it. In the layout of the related file, include a button to add items to the original file. The trick (and not knowing the details of what you want to do, I can't give you specifics) is to create the right relationship to the secondary file.