Jump to content

Automatic new record into a third file - lookup?


Ugo DI LUCA

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

Recommended Posts

I'm think I'm on the way to find the solution, but I need some help at a start.

I'm planning to create a Main Line Item Database, that would have at least 5 child files (Quote Line Item, CustOrder l.i.,Order l.i., Deliveries l.i., Invoices l.i.) linked to their relatives Databases (Quote Db, CustOrder Db,...).

A Unique ID will then be adressed to each file that would have same Quote N

Link to comment
Share on other sites

No, lookup brings related data back into the main file.

You need a script to make the new file. Scripting the process will be easy: integrating it into the interface will be the challenge.

Link to comment
Share on other sites

Do you know if the doscript plug-in could be used here to automate the creation of a record in my Main Line Item File as soon as a new record is created in the CustOrder Line Item File.

I would therefore set this kind of automation :

1. Traditional Script in Customer Db called "New Customer Order" :

External Script - CustOrder Line Item Db - Count current number of records:: define field "gcurrentN

Link to comment
Share on other sites

This topic is 7801 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.