Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to resolve Data Definitions with same name in TTX file

Status
Not open for further replies.

hlac

Programmer
Nov 20, 2001
7
CA
Hi, I've created a report using Active Data(TTX). I am passing a recordset to this report form VB. My problem is that the report generates repeated data for fields that have the "same name". Below is my TTX file:

***************************
; Field definition file for table: ADORecordset
Name string 50 John Smith
StreetAddress string 100 13234 - 20 Ave
City string 25 Surrey
StateProvince string 50 BC
ZipPostal string 20 V6V 1X1
Telephone string 25 604 123-4537
Fax string 25 604 202-3330
Email string 50 js @home.com
Name string 50 North America
Name string 50 Canada
***********************************************

The 3 "Name" fields are from 3 different tables.
e.g Agent.Name, Region.Name and Country.Name

The report only displays "John Smith" 3 times and not "North America" or "Canada"

Please help!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top