I am afraid you are going to have to search regardless - The only way you will get close to direct access to the record is to have the order number as Key1 - everything else is going to have to query with a where clause
--- In vantage@yahoogroups.com, effgroups@... wrote:
>
> I would rather not have to search since the order # is something its easy typed in and faster ti pull up a record.
>
> Ephraim Feldman
>
> -----Original Message-----
> From: "bw2868bond" <bwalker@...>
> Sender: vantage@yahoogroups.com
> Date: Fri, 15 Jun 2012 20:02:16
> To: <vantage@yahoogroups.com>
> Reply-To: vantage@yahoogroups.com
> Subject: [Vantage] Re: UD Form help
>
> Sounds like your best option would be to create a quick search and have it be the default search for UD10...
>
> --- In vantage@yahoogroups.com, Ephraim Feldman <effgroups@> wrote:
> >
> > Can someone help me on this
> >
> > Please
> >
> > Ephraim
> >
> > On Tue, Jun 12, 2012 at 5:08 PM, Ephraim Feldman <effgroups@>wrote:
> >
> > > Hi
> > >
> > > I have a table UD10 populated with Sales order data.
> > > The Key fields are PO # and CustID since we will create a UD record before
> > > we enter the SO in the system
> > > At the time the SO is entered a BPM will update the UD10 record with the
> > > SO # in the Number01 field.
> > >
> > > No i want to be able to open the UD10 Form and type in the order # and it
> > > should pull up the record if it exist.
> > > I dont know hoe to do this maybe someone here could help me?
> > >
> > > thanks
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>