Hi guys, i converted our works database to FMP7 yesterday and am having problems with lookup from one database file to another. The databases are products and quotes, i enter a product number and the lookup lists description and buy price. I have 100 lines listed and the first line works fine. When i tab to the second line and enter the product code i get the description but not the price. I have checked all relationships and all seems fine but i just cant get the buy price in the second line, or even third, fourth etc.

I have tried to convert again but same happens

Any help would be greatful

Please also email me [email protected]

Regards

Clive

FileMaker Version: 7

Platform: Windows XP

Clive,

My first thought is the alignment of your price field? The first line can display and the rest may not show. I'm assuming a portal in quotes with the relation to products based on the product code.

Hope this helps,

FileSquire