UD Table Ultra Grid on Part Maintenance Sheet

Yahoo Archive
1
Nice question Nathan...I posed the exact same question earlier this week
but got no response. What I did end up doing was getting an FKV to
UD101 and making UD101A a sub table to UD101 and linking an ultragrid to
that on the part tab. Just to try it out, instead of using script to
create the foreign key I modified the context menu in the client/res
folder to make the UD tables available. It works just fine. I then
created a button to launch the UD101 table (id much rather enter data
right into the grid) and passed the part number with the process caller
launch so if the part exists on the parent table it will at least open
that record set. Id like to take it one step further and get it to
create a new UD parent record if it doesn't find one...but that's where
im at. Email me if you want a copy of the customization...



Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site)



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of npbretscher
Sent: Friday, April 24, 2009 10:06 AM
To: vantage@yahoogroups.com
Subject: [Vantage] UD Table Ultra Grid on Part Maintenance Sheet





I need to create an ultragrid that stores data in a UD table that has a
many-to-one association to the part. I have created a sheet on Part
Maintenance and have added an ultragrid to the sheet. How do I get the
UD table available to be bound to the part and be maintained in the part
form? Is this possible?

Thanks. Nathan.





[Non-text portions of this message have been removed]
2
I need to create an ultragrid that stores data in a UD table that has a many-to-one association to the part. I have created a sheet on Part Maintenance and have added an ultragrid to the sheet. How do I get the UD table available to be bound to the part and be maintained in the part form? Is this possible?

Thanks. Nathan.
3
Hi Nathan,
There is some Help Available in System Help.
Please search Vantage Help for "foreign-key view option"
you will see this Topic;
"How can a user-defined table become a foreign key view option?"
and there is already example available with Vb.net Code, Follow the instruction and you will be able to have a available Datasource for that UD Table(after you test the Code) and you will have to just link that ultraGrid with that Newly added Data source.
Thanks
I you have any difficulty, let me know I think I have something similar done in our system, I can send you that too.
Â
Muhammad Sarfaraz
IT Project Manager
(Vista 8.03.305i - Progress )Â
Advance Grinding Service, Inc.
Tel: (708) 442 7100 x 313




________________________________
From: npbretscher <npbretscher@...>
To: vantage@yahoogroups.com
Sent: Friday, April 24, 2009 10:05:57 AM
Subject: [Vantage] UD Table Ultra Grid on Part Maintenance Sheet





I need to create an ultragrid that stores data in a UD table that has a many-to-one association to the part. I have created a sheet on Part Maintenance and have added an ultragrid to the sheet. How do I get the UD table available to be bound to the part and be maintained in the part form? Is this possible?

Thanks. Nathan.







[Non-text portions of this message have been removed]