newbie question

[Fntech]

Is it posible to see multiple list views (from 2 different tables) in one layout? For the invoices I am creating I need to show 2 different lists of data (items & services) on the same invoice. The two lists do not contain the same type of data, so I can't combine them into the same list. I hope this makes sense

Thanks

[transpower]

Yes--you have version 7, so you can have a list view in one window, another list view in another window, etc. Menu Bar | Window | New Window.

On the other hand, if you're actually referring to value lists (not list view), then simply create two fields, one for each value list.

[Ender]

No, you cannot have two List Views in the same layout.

You say this is to show Items & Services for an invoice, it seems to me Items & Services are just categories of invoice Line Items. If this is right, then just use one combined table for Line Items, and then for the printout, use sub-summary parts to group the line items into an Items section and a Services section. For data entry, you can enter the items in the same portal, choosing the Type in a field, or use two portals, one for Items, one for Services (The portals would be filtered by the Type.)

[Fntech]

Ender, thanks for the idea, I will try to reconfigure how I was going to create these invoices to use the same table like you suggested.

As a future feature I think it would be nice to allow for multiple list views in one layout. Maybe allow for multiple "body" parts, anyone else have this need?

[Ender]

As a future feature I think it would be nice to allow for multiple list views in one layout. Maybe allow for multiple "body" parts, anyone else have this need?

I've heard a similar request once before, for the same reason. The trouble with this is how would you define a found set? How does each Body part relate to the layout's table occurance? The sub-summary parts would have similar issues.

[Fntech]

I see your point, how about the ability to combine two layouts into a "master" preview or "group layout" for printing?

[Ender]

Well, the same reasoning applies.

One solution is to run each report in their respective file or layout and then print them together as one "Report" where page 1 is from the first report and page 2 is from the second.

Another solution is to use portals for one or both lists, though this has limitations when printing. Portals don't break well across page breaks, and they don't always slide well.

Another possibility I've heard of is to grab the data (or summary data) from the two lists, and put them into another table to build the report.

But if the data in the two lists is similar, like Items and Services, the best solution is to have them in the same table. This not only simplifies this report, it simplifies the design in other areas as well. You can always distinguish between the two by a simple text field "Type". Some fields may only be needed with one of them, but that's okay.