listing all data in related DB in the parent

[balooka]

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

JP

[BobWeaver]

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]

Print

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.

[balooka]

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!

JP

[BobWeaver]

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.