Hi everyone!
Little problem here, using eGroupware + MySQL:
file Members contains 1 record per coop member,
with about 1000 members
the member record contain 2 fields
of interest: city and street, plus
other fields that cause no problems
file Streets contains 1 record per street,
with 2 fields per street record:
city_name and street_name.
The user starts by browsing the Members file
and chooses a member record (object) to be edited.
So he modifies some fields, but when he wants
to modify the street field for instance, he isn’t
allowed to type it in, he must choose a street
name among those of the member’s city that are in
the Streets file.
To do that, there is a “choose” button adjacent to
the member’s record street field in the Member.edit
etemplate.
Clicking on that record opens a window that shows
all the street records for the member’s city, at
one line per record (using a NextMatch widget).
Clicking on the “select” button of a particular
street record should copy the street_name field
of that particular street record into the street
field of the member record beeing edited, then
refresh the window containing the member record.
Simple stuff, really, however…
I haven’t found how to transfer the selected street
name from the street object to the member object
that called it.
It is fairly easy to put the selected street name
into some particular global variable, for instance
I could assign it to $GLOBALS[‘street_name’], but
then how do I tell the Member object to go, fetch,
store in the street field and then display the
value of $GLOBALS[‘street_name’] once it has been
assigned ?
Is there a clean way or an easy way to do this ?
Thanks for any help!
Norman nwm@csur.ca
eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users
