Great. Let me know if you have any questions using dbFetch. -- Alan Little Phorm Support http://www.phorm.com/ On Thursday, November 21, 2002, 11:30:21 AM, you wrote: > The dbFetch sounds better because some of the foreign key fields will be > more dynamic that COUNTRY...some fields will be be updated and change > constantly so setting option values per below would not be possible > since there would be updates necessary...the OPTION VALUE would have to > be set by SQL. > -----Original Message----- > From: phorm-bounce@xxxxxxxxxxxxx [mailto:phorm-bounce@xxxxxxxxxxxxx] On > Behalf Of Phorm Support > Sent: Thursday, November 21, 2002 9:50 AM > To: Patrick Kwiatkowski > Subject: [phorm] Re: [Phorm:] Re: Foreign Keys > Well, you could simply have the IDs as the VALUE attribute of your > OPTION tags on your form. For example: > <SELECT NAME="Country"> > <OPTION VALUE="US123">United States</OPTION> > </SELECT> > But if you really want to retrieve the value from the table, you can > do that with the DbFetch plugin, available from the Phorm site. Then > simply include the appropriate variable in your MySQL logging. ------------------------------------------------- You are receiving this message because you are subscribed to the Phorm mailing list. To send messages to the mailing list, simply send email to phorm@xxxxxxxxxxxxx from the address you have subscribed. You may unsubscribe from the list by sending email to phorm-request@xxxxxxxxxxxxx with 'unsubscribe' in the SUBJECT field.