Invoice Lookup Problem
I am working with an Invoice.fp7 from filemaker startup solution. I have one doubt to clear. In the invoice page i have got product ID and Product Name fields. If I click Product Id field it will show values with a dropdown menu and by selecting one it will automatically add value to Product ID and Product Name. my doubt is .. Is it possible to do the same method to Product names?? Like If click product name it should show the dropdown and by selecting it should enter the value to Product id too. So Either i can choose product id or Product Name. I need those two fields lookup each other!
please help me for the solution