Hi! there, another new baby to FM. I need to override lookup field on aselective bases. I should explain here what I am attempting to do.

I am seting up a custom manufacturing retail database. With almost 5000 items and prices. I have created a relational database with 12 files.

When entering order the "item#"s is selected from a file called Products, which has all the items, as soon as item# is selected all other info( name, unit price, piece weight and ex price and so on) will auto fill in. However, once in a blue moon, well make it a thousand, I need to enter a item # ="other" ( manual entry of all other info, these are the items that are designed for one customer).

Currently I must choose all items from the related file, custom entry is not allowed. Is there way I can do this with script are something.

Thanks in advance to all

Keystone

As I understand you would like to edit the informaition in the ( name, unit price, piece weight and ex price and so on) fields when the item # ="other".

Normally these fields are not allowed for user entry or modifications?

Perhaps a button next to the item number, or perhaps the item number field it self

if it ="other" have a script go to another layout where all the fields allow for user input.

Or if you need to track the custom order stuff. Have a script that allows the user to go to the products database to enter a CUSTOM record. Where they actually create a record in products. Then go back and enter a "Custom-product" number where it looks up the info as you already have defined.