From: Cherrymo@hotmail.com (Cherrymo) Newsgroups: comp.databases.oracle Subject: Forms Date: 5 May 2002 14:17:27 -0700 Organization: http://groups.google.com/ Lines: 22 Message-ID: NNTP-Posting-Host: 213.224.83.174 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1020633447 18232 127.0.0.1 (5 May 2002 21:17:27 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 5 May 2002 21:17:27 GMT 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