On my DB I set up an auto import script when the DB is opened. It imports about 36 tabs of data from excel into my inventory table so it takes a few seconds to load everything then refresh the items with less than 0, older than 10 days, etc.

I wanted my DB to open to a specific layout used by everyone else without witnessing the import. My import was set to go to inventory then import. So basic thinking says take off go to inventory cause the script know where to put everything.

So I took it off and now my app opens to the main user interface layout without showing the import taking place. But now I get an error for not having a relationship and the script is halted.

When I replace goto inventory in the script its fixed. Is this normal and if so is there something I can do to speed up the import, cover it up and remain on the main layout?

You need to be on a layout based on a table occurrence for the destination table when you import. Until the import is done, the user will not have control.