JobMtl Change Log

Yahoo Archive
1
Ted, I don't know if you got your answer on this but here is my 2-bits of info.

The ChgLog.TableName is the active table (i.e. your JobMtl) and I think your ChgLog.Idetifier is your Master Table. Regarding Jobs, the Key2 field identifies JobNum~Assmbl~Op.

--- In vantage@yahoogroups.com, "tkoch77" <tkoch77@...> wrote:
>
> Hi all,
>
> I am trying to create a BAQ that will have a date range and project ID filter to select change log records. In the ChgLog table the job number is stored in Key1, however, Key2 holds a string like this 000905~1~70, which isn't very useful for anything. Is there anyway to link the chglog table to the jobmtl table, has anyone accomplished this?
>
> TIA,
>
> -Ted
>
2
Hi all,

I am trying to create a BAQ that will have a date range and project ID filter to select change log records. In the ChgLog table the job number is stored in Key1, however, Key2 holds a string like this 000905~1~70, which isn't very useful for anything. Is there anyway to link the chglog table to the jobmtl table, has anyone accomplished this?

TIA,

-Ted