Alex LL
|
| Posted: 05/13/2002, 5:45 AM |
|
Hello CChargers,
I've a table "Users" where users' information (id, name and login) are stored.
I've a record form that selects from another table (let's call it TableA) where only the user name is stored (once a user creates a new record).
I'd like to select in this form the user login too.
I can't duplicate field "userid" for a join with Users, so how can I manage this without adding a column to TableA to store users' login?
Thanks for help
Alex LL
|
|
|
 |
Nicole
|
| Posted: 05/13/2002, 7:27 AM |
|
Alex,
just add two userid fields, then go to field properties and assign them different name in 'Name' field. You'll be able to join fields from other table to both userid.
|
|
|
 |
|