Gossamer Forum
Home : Products : DBMan : Discussions :

Re: Last try: Select field also pulls related data

Quote Reply
Re: Last try: Select field also pulls related data In reply to
In Reply To:
When $rec{'School'} pulls the school's name I want the script to also pull the city and the country of that specific school.
CSky, are you meaning that when a record is added, you want the scripts to identify the City & Country associated with a particular School already in the db?

In Reply To:
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.
I don't know how your db(s) is/are set-up however, as a usual, each database record contains a value for each needed field - although many records may have the same value for a given field, without the value being entered for the particular record, the record is incomplete.

The only way I see around that would be to have "Schools" as a separate (relational) database - Each school would then have fields populated with the specifics of the school.

Perhaps I'm misunderstanding what you're attempting to do. Sorry :-(



Subject Author Views Date
Thread Last try: Select field also pulls related data csky 3439 Feb 9, 2001, 2:23 PM
Thread Re: Last try: Select field also pulls related data
Karen 3357 Feb 9, 2001, 6:09 PM
Thread Re: Last try: Select field also pulls related data
csky 3372 Feb 9, 2001, 10:19 PM
Thread Re: Last try: Select field also pulls related data
Karen 3368 Feb 10, 2001, 1:16 AM
Thread Re: Last try: Select field also pulls related data
csky 3343 Feb 10, 2001, 10:28 AM
Thread Re: Last try: Select field also pulls related data
LoisC 3328 Feb 10, 2001, 11:04 AM
Post Re: Last try: Select field also pulls related data
csky 3336 Feb 10, 2001, 1:23 PM