Frank - How are you capturing this "key" value since it is not the physician's name? I'm assuming you specify a variable, say vkey_var_name, to put it in as part of the combo box specs. Check to make sure the "key" value is getting into that variable and that it is still there just before you execute the EDIT USING ..... command.
That command should look like: EDIT USING formname WHERE key_column_name = .vkey_var_name where vkey_var_name is the variable specified in the combo box. Bernie ---------------------------------------- At 06:16 AM 11/30/2004 -0600, you wrote: >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. >================================================ > >
