yes checked the network issue, tried at different locations thinking it was my site maybe but still the same problem
contacted the hosting company who do not have any timeout restrictions so unsure.
i dont really want to programmatically link the tables if this error occurs as it will cause...