Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Posts
    49

    database design help!

    i've design a database for my shop that can handle buy,sell invoice and calculating stock of goods. but i want the database can handle money too like microsoft money does. but also linked to my current shop database. do i have to make a new database or i have to modify my current database? i have no idea to modify my current database so it can handle money in-out too.
    hendra gunadi

  2. #2
    Join Date
    Sep 2003
    Location
    Cincinnati, Oh USA
    Posts
    203

    Re: database design help!

    Give us a hint as to what database your using.

    Originally posted by hendra1211
    i've design a database for my shop that can handle buy,sell invoice and calculating stock of goods. but i want the database can handle money too like microsoft money does. but also linked to my current shop database. do i have to make a new database or i have to modify my current database? i have no idea to modify my current database so it can handle money in-out too.
    Rick Knight
    KnightShift Office Solutions and Horse Breaking
    VB, VBA, FileMaker, Access Solutions, Web Solutions

  3. #3
    Join Date
    Dec 2003
    Posts
    49
    my current database can handle buy,sell invoice and calculating stock of goods. also expenses (buy invoice) and income (sell invoice).
    you know in a store there is another aspect like expenses for salaries,electricity, loan interest , etc (accounting stuff). i want my database can handle this too so i can retreive information about how much money do i have now in bank, my debt to another store(my supplier), or another store's debt to my store(customer). something like that.
    hendra gunadi

  4. #4
    Join Date
    Sep 2003
    Location
    Cincinnati, Oh USA
    Posts
    203
    What database are you using? Access? Filemaker? What is the name of the application. Knowing this provides insight into answering you initial question.

    Originally posted by hendra1211
    my current database can handle buy,sell invoice and calculating stock of goods. also expenses (buy invoice) and income (sell invoice).
    you know in a store there is another aspect like expenses for salaries,electricity, loan interest , etc (accounting stuff). i want my database can handle this too so i can retreive information about how much money do i have now in bank, my debt to another store(my supplier), or another store's debt to my store(customer). something like that.
    Rick Knight
    KnightShift Office Solutions and Horse Breaking
    VB, VBA, FileMaker, Access Solutions, Web Solutions

  5. #5
    Join Date
    Oct 2003
    Posts
    87
    Originally posted by hendra1211
    my current database can handle buy,sell invoice and calculating stock of goods. also expenses (buy invoice) and income (sell invoice).
    you know in a store there is another aspect like expenses for salaries,electricity, loan interest , etc (accounting stuff). i want my database can handle this too so i can retreive information about how much money do i have now in bank, my debt to another store(my supplier), or another store's debt to my store(customer). something like that.
    Yes, you can write your own accounting package and house it's data in your current DB, however, why? There are probably many accounting packages you can purchase that can use your current DB.
    Oracle - DB2 - MS Access -

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •