setting fields trough a relation

[jeffer]

Hi,

I've got an invoice number in a database and some selected line items in another database. Does somebody know how to set the invoice number on those selected lineitems trough a relationship? I've tried the copy/paste solution with a script. But since that is a bad story for filemaker databases...i don't like to use it anymore!

Any help is appriciated...

greetz...jeff

[jasonwood]

Normally you create line items through an invoice, and the invoice number is the relationship... are you saying that the line items are already created, but you want to now add them to an invoice?

How are you selecting these line items? Through a found set?

How will they know what invoice to go to? Will a new invoice be created for these found line items?

[jeffer]

Nope....i use the ordernumber becouse the invoice numbers must countup, and since the user has got the abillity to cancel an order we use the ordernumber. Becouse that number doen's have to countup. Thus...the ordernumber is the relationship and the invoice number will be giffen when there is no way to cancel the order anymore.

I hope that this give you a better view to my problem!

thnx & greetz...jeff

[jnmorrison]

create an invoice number field in the line items database and make it a lookup to the invoice database::invoice number field. This way, when the relationship is established using the order number, the invoice will auto-lookup.

Jeff M

[Ugo DI LUCA]

I think I deal with the same problem for the moment.

I use an Invoice DB and a Central DB (your lineitem DB).

I create a New Invoice N