Hi,

I am building a FMServer 5.5 FMP 5.5 solution for Win 2000 / XP.

The solution includes a process for invoicing projects. The projects
database is one to many related to the project/ invoices line items
database.

I have designed 2 ways to "invoice" the line items.

1.- Global fields in Project database hold values that are passed to
the line items using portal and a loop in the Projects database like:

Go to first record
Set field 1 like global1
Set field 2 like global2
End loop

This loop is working fine (it is a little bit more complex than the
one I describe here)

2.- Go to related record, showing only related records and then
replacing values using a script in the line items database.

This is also working.

However, I do not like either solution. There are both slow and prone
to errors (some line items could be locked by a user, etc.).

Is there a better way to achieve this? I guess it is something that
many developers have been confronted with using FileMaker.

Thanks in advance,

Carlos