Hi All,

I've read both of Cathy Pountney's MSDN acticles and searched here for an anwser with no luck.

Using the VFP 9 "Target Alias" feature in the detail band. I've got two tables - Base_Tooling and Tool_Inventory. I've set a relationship between the two on the following expression:

ALLTRIM(STR(tooltypeid))+"-"+ALLTRIM(STR(moldid))+"-"+ALLTRIM(STR(dieid))+"-"+ALLTRIM(STR(insertid))

When I browse both tables and walk through the Base_Tooling the Tool_Inventory records show as expected.

Not using the Data Environment and it is empty.
I created a Data Group with the same expression.
I added "Tool_Inventory" as the target alias.
The Base_Tooling table is selected when the report is run.

In the Group Header I created a field control with the expression Base_Tooling.Tooling_Name
In the Detail I created a field control with the expression tool_inventory.location

The report ONLY displays the first tool_inventory record.

I created another report - Base Products. The only difference is the relationship and data group expression which is productid. This report works as expected.

Could the expression - ALLTRIM(STR(tooltypeid))+"-"+ALLTRIM(STR(moldid))+"-"+ALLTRIM(STR(dieid))+"-"+ALLTRIM(STR(insertid)) somehow be confusing the report writer engine?

These are very similar, simple reports so I can't figure out why one works and the other doesn't.

Any ideas?

Thanks!