| Conthist fields in word merge | |
Posted: Thu Mar 08, 2007 8:30 am |
Points: 0 |
|
sporter@gdynamic.com |
n00b |
|
|
Joined: 08 Mar 2007 |
Posts: 2 |
|
|
|
|
|
|
|
|
Successfully edited a field in my word merge doc to pull the createby field from the ContHist database and works fine when merging for one client, however when I merge a SQL group I receive an error message
Table does not exist.
Invalid field name.
Context: create
c:\docume~1\stacey\locals~1\temp\GM685.DBF
1: File: c:\docume~1\stacey\locals~1\temp\GM685.DBF
BDE Error Cat:Code: [39:54]
BDE: 500 [4/11/1999] GoldMine: 6.70.41114
Any help would be greatly appreciated |
|
|
|
|
| | |
Posted: Thu Mar 08, 2007 9:58 am |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
I'm impressed you got it to do it for a single merge. It's not going to happen for the multiple merge though.
You COULD, however, put together an SQL query that returns the proper information, export that as a .DBF and then use that DBF as the merge data source in Word -- side-stepping the entire GoldMine link add-in...
Keep in mind, however, that the createby in conthist is related to the contact in a 1-to-many manner. This means that any given contact could have hundreds (if not thousands!) of conthist entries. The question becomes, which createby value to do want? |
|
|
|
|
ContactReview Forum Index » GoldMine 6
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
All times are GMT - 7 Hours
Page 1 of 1
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|