Hi all,

I was just about to start on some elaborate code to do something, to which I feel a simple SQL might do the trick. Unfortunately, I can't get the trick!

I have 3 tables, which are basically Accounts tables which have different data, but certain common fields like ddate, cdetails, ncredit and ndebit. I need to create an updateable view which contains all the data from all the tables although on 2 tables I will be taking only the sum(ncredit), sum(ndebit) to prevent too many entries.Then, there's a certain unique linking field to create a link with the parent table if necessary, which will be used to create a sub-query if necessary, to display more detailed data from the individual table. The final view should look as if all the tables were merged into one neat view.

Any help, from anyone, please?

Regards,

Steve