Bryan
|
Posted: 10/08/2003, 7:43 AM |
|
Do field names have to be identical in tables in order to join them? I have two tables in my database, one has a "UserID" field, one has an "OwnerID" field which is the user ID of the owner. I want to join them so that I can look up a name from one of the tables to be used in a search. In the query builder, I can't get a join control to appear, just the table properties control. Am I doing somethign dumb? Do I have to change my field name in the second table to be "UserID" in order to join them with codecharge?
Thanks, Bryan
|
|
|
Smart One
|
Posted: 10/08/2003, 8:40 AM |
|
Bryan,
It does not matter the name of the joining fields....just map them and CCS will do the rest.
Good luck,
|
|
|
|