hi. doing a database assignment for my access class. i am a blind student at my college in australia. using ms access 2000, windows 2000, and using the jaws screen reading software and using version 5.10 for more information about jaws for windows go to http://www.freedomscientific.com now have had several problems. now if any one can give me some answers on how to fix the problems i am having. 1. one of my queeries which i built from a table and imported from excel. it has the primary key field set to number. but instead of giving me sequential numbers like 1.2,3, it only says 1,1,1, etc. should i try to set the data type back to autom number? will this fix this problem? also got the same problem with my report, it just keeps saying the id 1, for each record. it should say id 2. id3, etc. how do i fix this? 2. when i set up my relationships to the id fields in my tables in access , and try to tick the referential integrity, cascade update records, update deleted records, and try to click on create, it gives me a message saying the database could not lock the table, or that the data fields are not the same type, as they are all data type of number, and set to long integer. 3. i created several reports and sub report in collumna format. how do i resize the report and sub report using the keyboard? jaws will not let me use the mouse, or reads very erraticly. is there any third party software that will allow me to resize reports and sub reports in access 2000? if any one can help me, then e-mail me privately off list. cheers Marvin. ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************