jeffer Posted November 20, 2002 Share Posted November 20, 2002 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 More sharing options...
jasonwood Posted November 20, 2002 Share Posted November 20, 2002 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 More sharing options...
jeffer Posted November 20, 2002 Author Share Posted November 20, 2002 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 More sharing options...
jnmorrison Posted November 20, 2002 Share Posted November 20, 2002 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 Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted November 20, 2002 Share Posted November 20, 2002 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7955 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 accountSign in
Already have an account? Sign in here.
Sign In Now