I used the Tools > Relationships and dragged/drug the field in one table to the matching field in the other table, just like in MS Access. The second table was done the same way. I now have a lot of different tables with relationships between them. When I create the forms for data entry to these various tables it causes the same error because of the deleted table. I had created another table and set up the relationships for it and when I kept getting the error, I renamed the new table to the old table that had been deleted but it still didn't work. The problem seems to be with the SYS_FK_xxx tables that didn't get deleted when I deleted the table. Do you know where these tables are located and how they can be manually deleted/edited? Thanks -- View this message in context: http://nabble.documentfoundation.org/Relationships-in-Base-tp3780236p3780720.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted