Re: Forms Newbie question - help please

[Quoted] Yes I'm having a problem - sorry I think I deleted that part.

FRM-40508 ORACLE unable to insert record. When I try and change the name & save it.

[Quoted] [Quoted] As soon as I remove the association in the BILLTOBLOCK.CONAME to the LOV, I can insert and update records again.
[Quoted] Not the Billtocoid of course. So something isn't working right.

[Quoted] Is this the best method for what I'm trying to do?

Thanks for any input.
Lesley

"Matt B." <mcb_at_ds.znet.com> wrote in message news:t3dusm45p8h277_at_corp.supernews.com...
> "Lesley" <lesley_at_vimich.com> wrote in message
> news:FKsZ5.74252$i%4.2421701_at_news20.bellglobal.com...
> > Hello everyone.
> > Could someone tell me the best way to do this.....
> >
> > Here's the fields of concern in the COMPANYDIR table:
> > COID
> > CONAME
> > BILLTOCOID (fk to coid)
> >
> > Here's exactly what I've done....
> >
> > Created an additional Block (BILLTOBLOCK) that consists of BILLTOCOID
 and
> > CONAME
> > There's a relationship: BILLTOBLOCK.BILLTOCOID = COMPANYDIR.COID on the
> > master block.
> > I am only displaying the BILLTOBLOCK.CONAME on the canvas
> >
> > I have created an LOV (LOV_BT) based on the Query: Select COID, CONAME
> > FROM COMPANYDIR.
> > Column Mapping: COID mapped to BILLTOBLOCK.BILLTOCOID
> > CONAME mapped to BILLTOBLOCK.CONAME
> >
> > The BILLTOBLOCK.CONAME properties:
> > List of Values = LOV_BT
> > Validate from list = Yes
> >
> >
> > I want the user to be able to change the BILLTOBLOCK.CONAME and have
> > BILLTOCOID updated with the COID in the same record.
> >
> > Am I doing something wrong, or is there an easier way?
> > Thanks very much.
> > Lesley
>
> Well, if you are asking if you're doing something wrong, then does that
 mean
> you are having a problem? If you're getting an error or something, please
> share.
>
> Otherwise it looks like it should work.
>
> -Matt
>
>
Received on Wed Dec 13 2000 - 14:35:03 CET