Ok Ok I think you have heard enough from me but i did get the databases linked and now when it comes to the coding of the form like if i wanted to switch tables so that it adds the record to the right place i just do an if statement? please inform