Hi Michael,
I made that Foreign key, using PackNum from InvcDtl table but in new
rule, under that view "myview" I don't see any ShipDate field!!!
Would you please let me know if I did something wrong?
I do appreciate it.
Kam
--- In vantage@yahoogroups.com, "Michael McWilliams"
<mmcwilliams22@...> wrote:
I made that Foreign key, using PackNum from InvcDtl table but in new
rule, under that view "myview" I don't see any ShipDate field!!!
Would you please let me know if I did something wrong?
I do appreciate it.
Kam
--- In vantage@yahoogroups.com, "Michael McWilliams"
<mmcwilliams22@...> wrote:
>PackNum
> --- In vantage@yahoogroups.com, "kamvantage" <kkosari@> wrote:
> May or may not work.
> Have you tried doing a Foriegn Key View from the InvcDtl using
> and then use the ShipDate in that FKViewshiphead
> >
> > We have a requirement to prompt a message at RMA processing level
> based
> > on shipdate value, if its greater than 90 days.
> > When trying to define the trigger thru customization; the
> > table is not accessable at the order or RMA level to define thevalue!!
> trigger
> > or rule.
> > invcdtl table has shipdate, but it doesn't have the correct
> > We are on 8.00.809G
> >
> > Any assistance will be appreciated.
> >
> > Kam
> >
>