Check Book Registry Table Design

hooks

Registered User.
Local time
Today, 03:29
Joined
Aug 13, 2004
Messages
160
Hi all, Im updating my current checkbook registry database. Just want to be sure that table look ok to everyone before starting the coding process. This will be a multi user - multi account program. I have attached the relations diagram.
Please give me some suggestions as to what fields i might need to add.

Also check to relations.

Thanks a bunch.
 

Attachments

  • Relations.jpg
    Relations.jpg
    86 KB · Views: 260
Thanks Pat.

Thanks for pointing out the Date field problem. I haven't got into field names yet Im just trying to get the basic table layout figured out.

The problem im having is that multiple users will be using the database so i need a way to keep all of the Payees, PayeeDetails and PayeeCategories seperate for each user. I thought using the account would be the best way.

Say Lisa has a checking account and Cheryl has a checking account. I don't want them to see each others payees etc.

Hope this makes sense. Do you have a better way of achieving this?

Thanks Hooks
 
Let me rethink what im doing and ill post an update.

thanks Pat
 

Users who are viewing this thread

Back
Top Bottom