Rick Page
|
| Posted: 03/28/2002, 5:39 AM |
|
Hello Everyone,
I know that there is an obvious solution for my problem.
Here is the scenario:
Once someone has joined and their information is stored in a table with member_id as the primary key, they have an opportunity to join different groups.
They have to be logged in to signup for the different groups.
When they go to sign up for a group, I would like to pull their first and last name info from the members table and place them in the first and last name fields in a form for that groups table. So people in that group will be able to search for other members by name.
The Problem:
I tried capturing the member_id via session -> UserID, setting the name fields to labels, and joining table members -> member_id -> name fields. But when I log in as a member and go to the registration form for a group, the fields(labels) for first and last name are empty. Am I missing something? Is this due to not having a record yet for the group associated with the member_id?
Any suggestions would be appreciated.
Thanks,
Rick
|
|
|
 |
Nicole
|
| Posted: 03/28/2002, 6:42 AM |
|
Hello,
nonupdatable fields (Label, URL) should be duplicated with same Hidden fields in order to include them into sql statement.
To look up first and last name of logged in user on group registration form add pare of Label and Hidden fields for each field, assign different names for them in field properties. Look up corresponding values (first name, last name) in Before Show event and assign them both to Label and Hidden fields.
|
|
|
|
Rick Page
|
| Posted: 03/28/2002, 7:21 AM |
|
Thanks Nicole,
I was able to do a get_db_value in the Show Before Event.
I guess I was hoping that I wouldn't have to write custom code.
Thanks again,
Rick
|
|
|
|
|
