listing all data in related DB in the parent

January 17, 200322 yr

hi,

I'm working on a solution that holds a little data in the MAIN DB, and uses line_item db's to store other info. It's all working ok. The only problem i have now (and didn't figure out how to work around it) is that I want to create a list of all item in a related DB.

Example: one line_items holds 'raw materials'. I want the users to be able to print a complete list of available items stored in the line_item DB, without actualy 'opening' it. In other words, the way this solution is set-up is that only the main DB (with loads of portals) will be in front, all line_item DB's are hidden.

The easy way would be to create a scriptset that will generate the list in the respective line_item DB, but that would break up concistency in the workflow since another file will be shown. It would also mean I have to create new form lay-outs...

Any suggestions on this?

TIA

January 17, 200322 yr

You can script the printing from the related file without the user ever seeing it.

In your main file you have a script:

Perform Script [external, RelatedFile:PrintScript]

Refresh Window

In your related file you have the script that does the actual printing:

Page Setup [restore no dialog]

The trick is to make sure that you end up back in the parent file. By having the main script end with a refresh window step, it ensures that you finish up in the original file, and the user never sees the line items file.

January 17, 200322 yr

Author

Thanks

One more question about this:

If I set the pagesetup step in the parent script before it runs the related script, will it use that pagesetup?

IAW, can I still make 'page setup' available to the users without doing it in the external script, so I can use [resore no dialog] in the external script?

Thanks alot!

January 18, 200322 yr

The page setup always refers to the script from which it is run, so the innermost sub-script will always use its own page setup. So, you can remove the page setup from the sub-script and use one in the calling script, or just do the page setup once in the sub-script. Either way, the user still doesn't see the line items file.