MultiTable Group?

[sandora]

V11, Access DB

Is there a way to include 2 tables in 1 group. For instance I have two employees who split one deal and I need for both of them to appear in the group.

 

[synapsevampire]

You should try using technical terms to describe your data and output requirements. Your post could be interpreted many ways, simply because you didn't take the time to decsribe the requirement.

Since the database is Access, I suggest that you create a UNION query in Access to use as the data source, it's mopre flexible and faster that Crystal anyway as a database engine.

-k

 

[sandora]

I actually did post the technical stuff and got no response so I thought I'd try to solve it from a different angle. This is original post, but now I'm thinking its in the grouping.

V11,AccessDB This is an example of what my report looks like now.

GH1-SP1-Mikey
GH2-TrailerType-LQ
Detail-Deal# Gross Commissions

GH1-SP1-Howard
GH2-TrailerType-LQ
Detail-Deal# Gross Commissions

I have this report built and it works great, but now they've discovered that sometimes the Salespeople share deals and they need to be split between them. Each salesperson has a unique sales#. If only one person has the deal, the number is located in field SP1 of table2, if there is a second person, theirs is in field SP2 of table2. I've used this formula:

if isnull({sp2}) or {sp2} = "" or {sp1} = {sp2} then
{retial} else
({retail}/2)

and it returns all of retail values and splits the deal on SP1 but it doesn't show up in the detail on SP2 (the other half of the deal).

I added a second Emply# table alias. It is linked the same way as the other table. Still not showing up on the second person. Here are the tables and their links:

DB1: Emply Table, Emply Table1
DB2: Inventory table
DB3: Intro table, Profit table

Links:
Profit;Deal# to Intro;Deal#
Intro;Stock# to Inventory;Stock#
Intro;SP1 to Emply;Emp#
Inrto;SP2 to Emply1;Emp#
Emply;Co# to Inventory;Co#
Emply1;Co# to Inventory;Co#

I think part of the problem is with the @salesperson formula

{Emplytable.Lastname}&", "&{Emplytable.Firstname}

I think I need for it to look at the alias emply1 table also but not sure how?

Please help!