Lookup and Repeating Fields Problem

[whyjch]

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.

[dkemme]

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.

[whyjch]

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