OK, I'm having all kinds of trouble now.
I basically need to take the value in a field on the screen, nedDMRNum, and use that value to hit the NonConf table & find the NonConf.RMANum value through the Script Editor code.
I'm having a lot of trouble with the code. I have the Epicor Tools User Guide, but it isn't much help.
Using Object Explorer to copy & paste code to the script editor & keep getting nowhere. Just errors that it isn't recognizing its own code.
Can anyone please assist? Thanks!
I basically need to take the value in a field on the screen, nedDMRNum, and use that value to hit the NonConf table & find the NonConf.RMANum value through the Script Editor code.
I'm having a lot of trouble with the code. I have the Epicor Tools User Guide, but it isn't much help.
Using Object Explorer to copy & paste code to the script editor & keep getting nowhere. Just errors that it isn't recognizing its own code.
Can anyone please assist? Thanks!
--- In vantage@yahoogroups.com, "millermw7" <millermw7@...> wrote:
>
>
> Yeah, I was hoping I could keep it simple instead of going the .net & form event route.
>
> At any rate, thank you VERY much for your help!
>
>
> --- In vantage@yahoogroups.com, Rob Bucek <rbucek@> wrote:
> >
> > Especially in 8, the foreign key views are fairly limited to primary keys, and even then not all tables are directly supported through the wizard depending on what you want to link and where you are linking from. You can create your own custom foreign key view through .net code in the script layer, your other options are moving it to a UD field in the DMR when it's created or some other method is called, or you could even bring it in through .net based on a form event. None of those options are as simplistic as the foreign key view though. I don't think you're missing anything in this instance though.
> >
> >
> >
> > Rob Bucek
> > Production Control Manager
> > PH: (715) 284-5376 ext 311
> > Mobile: (715)896-4832
> > FAX: (715)284-4084
> > [cid:1.234354861@]<http://www.dsmfg.com/>
> > (Click the logo to view our site)<http://www.dsmfg.com/>
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of millermw7
> > Sent: Wednesday, April 10, 2013 9:35 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Foreign Key View help 8.03.404B
> >
> >
> >
> > Ok, admittedly I'm very new to Vantage & didn't see much for an explanation already in the group, but here goes...
> >
> > I'm trying to tie the RMA number from the Nonconformance screen (Production Management->Quality Assurance->General Operations->Nonconformance) to the DMR Processing screen.
> >
> > I've gone into developer mode & customization & added the field I need, but need to tie the data to it.
> >
> > When I try and create a Foreign Key View using DMRHead as the Parent View, The Column Name dropdown under Foreign Key View Info doesn't have anything I can really link to the NonConf table (to retrieve the NonConf.RMANum value).
> >
> > I can link on PartNum, but that just connects to the Part table & has all the Part columns. Logically, I should be able to do a join on the NonConf & DMRHead tables on DMRHead.DMRNum = NonConf.DMRNum.
> >
> > Not understanding how this Foreign Key View & Custom Column Like thing works. This should be a simple join in SQL...
> >
> > Thanks to any & all for the help, letting me be part of the group, & I hope to be giving a lot more back to the group in the future!
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>