Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2014

    Unanswered: Relationship in my front end db ?

    I was creating a form by form wizard that has fields from 3 tables that is located on my back end db. When I finished the process, it informs that I don´t have relationship between the tables and then I was dropped in mey front end relationship tab.

    These tables are all related in my back end db, why is that happening?

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    check you havent got one or more tables in the front end AND the back end.

    you can only define relationships in the same Access file that has the tables in. you cannot defines relationships between tables in different files, nor in tables that are not the current access file you have open.

    check the tables have relationships defined in the back end
    check the tables in the front end that are linked to the back end point to the correct back end
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts