adding records in portal by lookup

[ronbob]

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

[comment]

Third reading, and still no understanding.

[ronbob]

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.

[comment]

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?