Bernie, the key value is an actual key of the table. The statement I am using is "edit using scr_physician_chg where phy_id = 7" 07 is the value of phy_id in the physician table, phy_id is also a primary key.
Frank -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bernie Corrigan Sent: Tuesday, November 30, 2004 3:18 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Edit Using Frank - I don't understand the term "key value." What does it mean? Are you referring to the contents of the field selected from the drop down? Bernie At 10:46 PM 11/29/2004 -0600, you wrote: >I am using a form using edit. I have a screen where the user selects a >physician from a drop down list where I capture the key information. I >then issue an "edit using form-name where key = value". The form comes >up fine, however it is blank. If I select any thing from one of the >drop down combo boxes the form fills all fields with the correct >information. What do I need to do in order to get the form to come up >filled in with the information identified by the key value supplied. > >Much thanks. > >Frank >Technology Solutions, Inc. > ><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> ><HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; >charset=us-ascii"> <TITLE>Message</TITLE> > ><META content="MSHTML 6.00.2800.1476" name=GENERATOR></HEAD> <BODY> ><DIV><FONT face=Arial size=2><SPAN class=968224104-30112004>I am using a form >using edit. I have a screen where the user selects a physician from a drop >down list where I capture the key information. I then issue an >"edit using >form-name where key = value". The form comes up fine, however it >is >blank. If I select any thing from one of the drop down combo boxes the >form fills all fields with the correct information. What do I need to do >in order to get the form to come up filled in with the information identified by >the key value supplied.</SPAN></FONT></DIV> ><DIV><FONT face=Arial size=2><SPAN >class=968224104-30112004></SPAN></FONT> </DIV> ><DIV><FONT face=Arial size=2><SPAN class=968224104-30112004>Much >thanks.</SPAN></FONT></DIV> ><DIV><FONT face=Arial size=2><SPAN >class=968224104-30112004></SPAN></FONT> </DIV> ><DIV><FONT face=Arial size=2><SPAN >class=968224104-30112004>Frank</SPAN></FONT></DIV> ><DIV><FONT face=Arial size=2><SPAN class=968224104-30112004>Technology >Solutions, Inc.</SPAN></FONT></DIV> ><DIV><FONT face=Arial size=2><SPAN >class=968224104-30112004></SPAN></FONT> </DIV></BODY></HTML> > --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [EMAIL PROTECTED] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
