Combining Item Master Description with Alternate Description

I am writing a item master find/browse program that needs to have the capability to do the following.

1. When I type in Description it look at the language preference and pull back either the IM descripion or the Alt desciption.

For example

Item 1 Description is in French and stored in the Item Master
Item 2 Description is in English, so I need it to pull from the Alt Description.

So when they type in a description is looks at the French language and pulls in the record based on the if there is a French record in the Alternate Description.

Say I type in *FrenchItem* in the description

Item 1 has FrenchItem in the F4101
Item 2 has Engli[censored]em in F4101, but needs to pull the description FrenchItem from the F4101D

Can someone please help

your you need to look for for anyone of the two descriptions?
F4101 AND F4101D?

you can use a view left outer join between F4101 and F4101D and in the FIND & BROWSE, enables a field in which you indicate the language in the form.
with the left outer join you make sure that if you don't have registered alternative description, continue seeing the original description