Dave, I sent this message a few days ago as an attachment but didn't get my copy back from the list as normal, so I'm sending it again in the body of this message in case it didn't get through to you. This using Office 2003. Jim Williams Creating a Relationship Select Tools (Alt T) then Relationships The two tables are displayed on a relationship page Relationship menu (Alt R) select Edit Relationship Edit relationships box is displayed Tab to Create New (Alt N) and enter Create New box will be displayed The left table box will be selected or (Alt L) - down arrow and select the 1st table Tab to Right table box (Alt R) - down arrow and select the 2nd table Tab to Left Column Name box - down arrow and select the relationship Tab to Right Column Name box- down arrow and select the relationship Tab to OK and enter Tab to Enforce Referential Integrity box (or Alt E) and press spacebar to select. (NB this will ensure that you cannot delete fields from one table that are related with another). Tab to Create button (Alt C) and enter to create the relationship If you need any notes on removing a relationship then let me know. -----Original Message----- From: jaws-uk-bounce@xxxxxxxxxxxxx [mailto:jaws-uk-bounce@xxxxxxxxxxxxx]On Behalf Of Ankers, Dave (UK) Sent: 10 February 2009 15:01 To: access-uk@xxxxxxxxxxxxx; jaws-uk@xxxxxxxxxxxxx Subject: [jaws-uk] JAWS doesn't access Access Hi All, I am resending this as no one as, yet has responded. I am having an issue with JAWS not setting up relationships in Access. In the relationships view, I select the field, and press Control+Shift+ C, and JAWS informs me to select the table and field to which I would like to link, and press the same combination again to set up the relationship. I do this, but no relationship is set , anyone have any ideas what might be the reason? Both tables have primary keys and exist in the database, not linked to external spreadsheets. Cheers Dave Ankers I would like to hear from anyone who knows if the later versions of JAWS, I have version 8! works better with Access 2003 as: JAWS fails to read the "Show" and "Criteria" fields in design view. JAWS fails to set up relationships in either design view using Control + shift + J, or in relationships using Control + shift + C. Plus when a relationship is set using the mouse pointer (by a sighted person), JAWS fails to announce the relationship when selecting the related field from a table. I have also found that when scanning across a large datasheet, JAWS fails to announce the column header when the column was initially out of view. Last and worst of all, if there is a glitch, and there have been a few, JAWS fails to speak until Access has been completely closed down. Meaning the software should be called Job Access Without Speech! Has anyone had scripts written to improve the usability of JAWS with Access 2003? Cheers Regards Dave Ankers ******************************************************************** This email and any attachments are confidential to the intended recipient and may also be privileged. If you are not the intended recipient please delete it from your system and notify the sender. You should not copy it or use it for any purpose nor disclose or distribute its contents to any other person. ******************************************************************** ** To leave the list, click on the immediately-following link:- ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** jaws-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq ** To leave the list, click on the immediately-following link:- ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** jaws-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq