To me it looks like there might be a language issue here and repeating the questions will not redress the issues. It is possible that - there are 5 tables one each for 5 locations which are not networked such that there are 5 databases. - the OP is collating the information from each location and re-organising it centrally in one table in yet another database. If words are difficult, some clarity using examples may be enough to understand - whether the 5 tables need to be linked - whether the 5 tables can be processed sequentially - what happens when any client visits multiple locations/stores