Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Change Autonumber to Manual number
I have a database with 3 tables. I created 2 tables with the ID fields as the primary key and the data type autonumbers. The 3rd table ID field is also the primary key, but the data type is number. Data type - number - would work so much better for my other tables, but because of...- PaulaB
- Thread
- Replies: 2
- Forum: Microsoft: Access Tables and Relationships
-
Indexing both FirstName and LastName fields together
I have a large database with many forms and subforms. My users can't always remember names previously typed in. If I set the "lastname" field to indexed - no duplicates, they won't be able to have both John Smith and Joe Smith in the table. Is there a way to set the table to index both...- PaulaB
- Thread
- Replies: 1
- Forum: Microsoft: Access Tables and Relationships
