Search results

Thats exactly what I want to do (create four back end dbs so that each department cannot see the records of the other) Many thanks

I have a large database of Purchase Orders Orders can be placed by people in one of 4 departments I would like to automatically make 4 separate databases (so each department can access their own) from the master Is there a way to do this?

I have a database of purchase orders Many of the purchase orders have a revision No against them, eg:- Purchase Order No / Line No / Revision No / Value 1001 / 001 / 00 / £50 1001 / 001 / 01 / £100 1001 / 001 / 02 / £200 I am trying to find a way to write a query that will show me the...