Importing a table does NOT import the relationships

[Bazsl]

Using Access 365 I import a table from another database that is identical to the current database except the source database has one additional table with relationships. When I import the table then view the relationships the relationships for the new table are not there. I am certain that I did check the Relationships checkbox when importing. Any idea what I am doing wrong? Thanks.

[ranman256]

Stop importing tables,and import the data.
either attach the extenal tbl then run an append qry to add the data to your table (w relationship already there)
or
use the transferdatabase to append data ,not make new table.

[Bazsl]

There is no data. The goal is to add an empty table and its relationships to a database at a remote location. I do not have remote access to the PC at the remote location so the import must be done by someone there using written instructions that I provide. The documentation on the MS Web site clearly states that importing a table will import its relationships as long as the Relationships checkbox in the import dialog is checked but I cannot get this to work. The table is imported but the relationships are not. I assume, therefore, that I am not doing something correctly. The question is, what?

[CJ_London]

It sounds like you are only importing a single table (OK into a db where those other tables already exist). But I think you will find that relationships are only imported when all the related tables are imported at the same time.

You could provide your user with a queries to create the table and its relationships - see

http://www.w3schools.com/sql/sql_create_table.asp to create a table
http://www.w3schools.com/sql/sql_create_index.asp to add indexes
http://www.w3schools.com/sql/sql_foreignkey.asp to add foreign keys (relationships)

[Bazsl]

Thanks Ajax. I was hoping to avoid using SQL to create the relationships since Access does not provide a means to execute a SQL script. However, SQL seems to be the only solution. Thanks again.

[CJ_London]

Access does not provide a means to execute a SQL script

you would use vba.

you could just send an 'update' db - written instructions would just be - open this db

write vba code in a module to execute the three queries and exit the database and have the sub activated by an autoexec macro - or in a form if you want to show progress

code would be something like (not checked for syntax)

Public Sub doUpdate()
dim db as database

    set db=opendatabase("existing backend")
   db.execute ("create table....")
   db.execute("create index....")
   db.execute("alter table...") - note this can be done as part of the create table sql
   db.close
   msgbox "backend updated"
   docmd.quit

end sub