Link another table to OEPRICFIL_SQL

[DBergkamp10]

Hi there,

Just updated to Progression 7.7 on MS SQL, and I am noticing that all of the pricing info has been migrated into just the table OEPRCFIL_SQL. The only logical field of reference that I can see if I wanted to combine two tables in a query is OEPRCFIL_SQL.Filler_0001, if I were to say, link it to an item_no in IMITMINV_SQL.

The problem is the item numbers in the OEPRCFIL_SQL.Filler_0001 seem to be preceded by in some cases a 'W' and then 4 spaces before our product number.

I have used mid(OEPRCFIL_SQL.Filler_0001, 6) to create a field which shows only the item number, and therefore discarding any other characters in the field.

Does any see an issue with this?
I'm doing it in VBA.

Thx

Dennis

 

[dgillz]

Updated from what? The pricing has pretty much been there forever, at least in the SQL version of Macola.

You are correct in dicing up the filler field to link to other tables. However you can use this in crystal except to link a subreport.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[DBergkamp10]

Belated thanks, I was able to figure this out.