i hope someone can help with this. third posting.

how to add records in portal using lookup. that is, selecting every record in lookup. i have two fields in the portal the first is a lookup to a client database, the second is quantity which is a calculated value. i simply want to have one script which will add all records from lookup and insert the calculated value in quantity.

thanks in advance.

ron

Third reading, and still no understanding.

let me try again. i need to add records automatically in portal to all clients via lookup. the script has to selct every record in the lookup, insert a new record for each related lookup. the second field in the same line is a quantity and the value is a calculated value which is also entered automatically for each line (set by calculation). i need an automted system where the quantity of one product is allocated to all clients at once.

its like an invoicing system only i make the decision for all clients/warehouses at the same time at once automatically.

1. The term "lookup" has a very precise meaning in Filemaker. I don't think you are using the term in this meaning - hence one cause for the confusion.

2. If you are the one making the decision, then it cannot be automatic - hence another confusion.

I understand (vaguely) that you want to specify a product, an available quantity for this product, and then have a script generate invoices so that every (?) client gets a portion (the same portion?) of the available quantity?