Gossamer Forum
Home : Products : DBMan : Discussions :

Last try: Select field also pulls related data

Quote Reply
Last try: Select field also pulls related data
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


Subject Author Views Date
Thread Last try: Select field also pulls related data csky 3371 Feb 9, 2001, 2:23 PM
Thread Re: Last try: Select field also pulls related data
Karen 3287 Feb 9, 2001, 6:09 PM
Thread Re: Last try: Select field also pulls related data
csky 3303 Feb 9, 2001, 10:19 PM
Thread Re: Last try: Select field also pulls related data
Karen 3298 Feb 10, 2001, 1:16 AM
Thread Re: Last try: Select field also pulls related data
csky 3274 Feb 10, 2001, 10:28 AM
Thread Re: Last try: Select field also pulls related data
LoisC 3259 Feb 10, 2001, 11:04 AM
Post Re: Last try: Select field also pulls related data
csky 3267 Feb 10, 2001, 1:23 PM