This topic is locked

Adding date to two fields

11/9/2006 6:24:02 AM
PHPRunner General questions
J
jmsakura author

Hi,
I want to add from the edit page The name of an individule using a drop down box to Two fields within the same table at the point and time of entry.
Table = Tblprospects

Dropdown box field Proconsultant

second field Procaseowner

Alexey admin 11/9/2006

Hi,
I'm not sure I understand you properly.

Please try to rephrase your question.

J
jmsakura author 11/9/2006

Hi,

I'm not sure I understand you properly.

Please try to rephrase your question.


Hi,
Yes, I need to have a field with the consultants name added and at the same time need to add this name to another field within the same table. This is to enable me to change the name of the consultant at a later date but always keep a record of the first consultant that was dealing with the case.

Alexey admin 11/9/2006

Hi,
I recommend you to leave only one of your two fields on the Add page, i.e. Proconsultant.

Then proceed to the Events tab in PHPRunner add this code to Before record added event:

$values["Procaseowner"]=$values["Proconsultant"];


Please note that field names are case-sensitive here.