Jump to content

setting fields trough a relation


This topic is 7826 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 7826 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.