Creating database for Multi User

[zahin]

Hi, I wish you guys a very great day! I am now developing an assets and liabilities application. How can I separate different records from different user in a database. I intended this application to be an offline stand alone database. Here are some details.

Tables:
1) User_tbl. Consist of: Username, Password
2) Personal Details_tbl. Consist of: Name, ID No, Date of Birth, Contact
3) Assets_tbl. Consist of: Type of Asset, Account No, Bank Name, Current Value



What is the best way for me to develop a database so that if I give this application to end user, they can register their assets based on individual's assets. For example, by using single application; Father has own login ID and can register his assets, Mother has her own login ID that consist of her assets data. Is there any possible of doing this? Thank you so much for your wisdom! I do appreciate your idea! Thanks!

[zahin]

I think I have problem with the relationship because currently the system works only for single user.

[ItsMe]

...How can I separate different records from different user in a database...

Create a table that lists all of the users. Store the Primary Key value from tblUsers in the events table tblAssets (use a Foreign Key field) and in the other events table tblLiabilities (use a Foreign Key field).

[zahin]

Create a table that lists all of the users. Store the Primary Key value from tblUsers in the events table tblAssets (use a Foreign Key field) and in the other events table tblLiabilities (use a Foreign Key field).

Thank you so much ItsMe! Will work on it!