Hello,
I am a little stumped. I have 2 databases, one which contains a UserID field that is the $db_key, and the other that contains a 7 digit number as its $db_key. There is a one-to-many relationship between the two databases. My problem is that I want to use the &build_select_field_from_other_db sub to fill a select field on the search page with user names that are associated with the UserID field of the second database. This works fine, except that the search always fails because the user names are not present in the first database, only the UserIDs are. My question is: How can I give the search routine the UserID value from the select field, and keep the user names in the select field?
Thanks
Keith
I am a little stumped. I have 2 databases, one which contains a UserID field that is the $db_key, and the other that contains a 7 digit number as its $db_key. There is a one-to-many relationship between the two databases. My problem is that I want to use the &build_select_field_from_other_db sub to fill a select field on the search page with user names that are associated with the UserID field of the second database. This works fine, except that the search always fails because the user names are not present in the first database, only the UserIDs are. My question is: How can I give the search routine the UserID value from the select field, and keep the user names in the select field?
Thanks
Keith