I am creating a simple Invoice layout, step by step, which uses repeating fields and lookups. The first lookup field worked well, i.e. when I enter the data the related data is looked up and entered into the layout. I then added a second lookup field. What happens now is that when I enter the data for the first entry, the related data is looked up successfully in both lookup fields. When I enter the following items (the repeating fields are set to a maximum of 6 entries) the first lookup I built works each time, but in the second lookup field the related value overwrites the first item. In other words it looks as if the field is not repeating. Am I missing something in the setting up of the fields? Any help would be gratefully appreciated.

Hate to not answer your question but why not get rid of the repeating field? They will just cause you many more headaches in the future. Create a table that has some relationship to the invoice for the repeating field that allows creation of new records, place it in a portal on the layout, the popup will work great and you can have as many or as few entries as needed.

Doug,

Thanks for your suggestion. I think the problem was caused by the relationships I had set up. With a bit of tweaking things are now working as I anticipated. Until the next 'headache'?

Thanks again.

whyjch