Most kindly I have been referred to the FAQ regarding this question, but it just seems as if there isn't any example that touches exactly this specific question and my knowledge of PL is quite limited.

I'll try to explain it the easy way:

This is my database (example):

xxxxx;School;City,Country;xxxxxxx

I would like to have a select-box (here it is):

&build_select_field_from_db("School", "$rec{'School'}")

Now, the select-box pulls out the School's name (so, we can say that this specific school exists in the database).

That school also has a related city and a country in the same record.

When $rec{'School'} pulls the school's name I want the script to also pull the city and the country of that specific school.

Then all the three would be filled in the School and the City and the Country fields automatically and the user that chose the school wouldn't have to fill in a city called Seatle when there is already a city callede Seattle in the database.

Anyone who can help me other than referring me to the FAQ, please reply!

CSky