I have also hit the road block you have Dick.
In programming and database design the memos and the change log were created
with this universal design concept which makes them attached to different
areas of the system with out rewriting and creating things from scratch. The
trade off is you create goofy table joins to universally connect and store
data which we have to live with. This ranks right up there with sales reps
stored in a string in field.
Patrick Winter
-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Wednesday, March 31, 2004 9:54 AM
To: Vantage (vantage@yahoogroups.com)
Subject: [Vantage] Joining OrderRel to Memo table
I sent this post yesterday and received zero responses. Possibly it has
never been done!
I am trying to join OrderRel to the Memo table. (the memo table defies
logic)
Anyway, I have created my calculated "RelatedToFile" entry and have joined
to Company and then to RelatedToFile. I want to link to key1, (orderno)
key2, (lineno) and key3 (relno). These fields are numeric and do not show
up as valid join fields. I tried to convert them to character fields but
they still do not show up to link. I also tried to convert the character
fields in the memo table to numeric, but that did not work either. I has
requested help from Epicor, and they are looking into it.
Why in the H*** is it so hard to get information from this table?
thanks,
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
In programming and database design the memos and the change log were created
with this universal design concept which makes them attached to different
areas of the system with out rewriting and creating things from scratch. The
trade off is you create goofy table joins to universally connect and store
data which we have to live with. This ranks right up there with sales reps
stored in a string in field.
Patrick Winter
-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Wednesday, March 31, 2004 9:54 AM
To: Vantage (vantage@yahoogroups.com)
Subject: [Vantage] Joining OrderRel to Memo table
I sent this post yesterday and received zero responses. Possibly it has
never been done!
I am trying to join OrderRel to the Memo table. (the memo table defies
logic)
Anyway, I have created my calculated "RelatedToFile" entry and have joined
to Company and then to RelatedToFile. I want to link to key1, (orderno)
key2, (lineno) and key3 (relno). These fields are numeric and do not show
up as valid join fields. I tried to convert them to character fields but
they still do not show up to link. I also tried to convert the character
fields in the memo table to numeric, but that did not work either. I has
requested help from Epicor, and they are looking into it.
Why in the H*** is it so hard to get information from this table?
thanks,
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links