Re: Forms

in the property pallette for the lov.. look at column mapping properties, ensure the key is being returned in to the id field and not just the code in the display field

"Cherrymo" <Cherrymo_at_hotmail.com> wrote in message news:ab2ca072.0205051317.4762094b_at_posting.google.com...
> hello,
>
> I need some help around here. We made a form where you have in the
> top the locationID (city code) and next to it you receive, by a lov
> the locationname. But now my problem is that the table under this
> form is not changing when I change the citycode. How can I change it
> with a trigger or do I have to make a link in the forms. In the table
> standard there is also the locationID.
>
> Can someone tell me what I have to do because I tried everything and
> nothing works. So I have table Location with Location ID and location
> name. When I change the location ID by a LOV automaticly the
> locationname is changing. But the info in the table Standard, which I
> let see under the form of location, is not changing and stays on the
> first informationline.
>
> I would be very happy if I find this solution to my problem so I can
> move on with the rest of the work and forms.
>
> Thx already for helping me out
>
> Cherrymo
Received on Mon May 06 2002 - 05:14:22 CEST