Hello, i have a table named "future_shift" its records have the following fields: "id" (key field), "volunteer_1", "volunteer_2", "timeshift".
Then i have another table, in the same database, named "shift", with its records having the same fields name of the "future_shift".
I'd like to auto populate the fields "Volunteer_1", "Volunteer_2" and "timeshift" in "shift" table on the base of the ID entered.
For example, if in table "future_shift" it have the following record:
ID = 5, volunteer_1= john, volunteer_2 =peter, timeshift= 1/1/2010 12:00
the user working on table "shift" should be able to enter value "5" in the ID field and then having the fields volunteer_1, volunteer_2, and timeshift: 12:00 with the data taken from the record with ID 5 in the future_shift table
If the user won't enter any value in the ID field into "shift" table, then he should be able to fill the fields as he likes. Fields should be normal text fields (not dropdown).
Any help?
Thank you in advance.
Flavio
