This topic is locked

Lookup table - passing more Values ?

3/2/2005 3:46:07 PM
PHPRunner General questions
author

Problem: If Passing fields values after table lookup is possible?
Database - tables Working good.
Note: For the purpose of my problem solving I only bring up two tables in question,
Table: Players

Table: Course
Course Table Fields:
Course_Name

Course_par

Course_Slope

Course_rating

.

.
Scores Table Fields:
Scores_Player

Scores_Course

Scores_Par

Scores_Slope

Scores_rating

.

.
I do want to know if PHP-RUNNER allow me to modify the script to be able to pass more values after the lookup table is performed.
Example: When I am entering the scores I call the course table to choose the course played.
The table course has some fields that holds important values, values that I want to pass to the scores table at the time of choosing the course or after submiting the form. For example: Scores_Par = Course_Par
I am working at the moment with the adding script over looking variables and functions scripts.
Well, maybe somebody has a better view of my problem and can tell me if I am waisting my time or we do have a solution.
I am working on a javascript function to intercept field inputs, but maybe you guys can bright me with some PHP_RUNNER code changes.
I do need to know if this is possible or not.

Sergey Kornilov admin 3/4/2005

Hi,
here is what you can try:

modify lookup wizard to select several fields using some separator. Then split this value using javascript and insert field values into Add/Edit form.

spettinato 5/30/2008

Hi,

here is what you can try:

modify lookup wizard to select several fields using some separator. Then split this value using javascript and insert field values into Add/Edit form.


Hi, can you tell better how? and in recent version, is there something i can use to do it?