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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
One to many relationships
I have 2 tables, one with an persons name and another table with one to many designations they have with the year the designation was obtained. The output is coming out as follows: Smith, John (AAA 1999) Smith, John (BBB 2000) I need the format to be as follows: Smith, John (AAA 1999, BBB...- jmargie
- Post #4
- Forum: Business Objects: Crystal Reports 2 Data Access
-
One to many relationships
I have a 1-m table relationship where an individual can have multiple designations. For instance, Joe Smith can be an ASA, FSA, MIID and DAS while Mary Jones is an ASA, FSA, and MPD. Each designation is part of a 1 to many relationship in a different table than the individuals name. I am trying...- jmargie
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 2 Data Access
-
*N Appended to AS400 DB2 table names
I am having a problem with a "*N". being appended to table names when attaching to an AS400 DB2 database through ODBC. I can manually change the table names through the Set Location function in Crystal Reports, but I am trying to create a Crystal Dictionary and there is no function to...- jmargie
- Thread
- Replies: 0
- Forum: Business Objects: Crystal Reports 4 Other topics
