can i change my id (auto number) field with my rollno. field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have facing a problem in access in student table. here a auto number id
field is avialable. i don't want this field, iwant the rollno field become a
my id field when i puting a rollno then he show me all record. can it
possible can i replace my id field with rollno field .


Plz solve this problem


2nd is that can i intagrate a students photo to my table so when i puting a
rollno then all information is coming with photo. in brife can i attach the
photo to my table?
 
The answer to both question is yes. You can create an OLE object field in
the student table and either insert the photo or link to the photo.
You can simply add the rollno ID and leave the autonumber ID in the table.
Replace the current ID with the rollno in all your forms and reports and add
it to you queries. Don't delete the autonumber ID as it may be used as a
link to other tables.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Entry Form and Auto Number ID 2
auto number fields 2
Showing ID field 6
Data seperation for form with many fields 7
Auto populating fields from another table 3
Auto numbering 1
Auto Generate Primary Field Value 5
Auto Numbering 5

Back
Top