AnsweredAssumed Answered

Multiple clients to one database

Question asked by MartijnBruggeman on Dec 13, 2010
Latest reply on Dec 13, 2010 by philmodjunk


Multiple clients to one database


Hi all, 

I want to set up a FM-database for 3 clients. In this database this 3 clients can register their customers for providing financial advice for their products by our company. I want to create 1 database, so I can make a report of my 3 (delivery) clients for my own use. So the 3 tables (each client have their own table) must be linked to 1 table.

At the moment i have the database running for 1 client. I based the current database on the included template "contactlist".

Now i have to add the 2 other clients. They may not see/edit each other's fields. So by differents security levels, logins (i think) they can only log in/edit  their own tables.

What customers can enter:
Customer ID (only their own client)

What customers should only see:
Results advice (only their own client)

Anyone have any idea how to be organized?