Search results

  1. L

    Normalization

    I currently have a database which I believe is in 3NF. It's completed as such, but I have recently come accross normalization methods. Because of this I would like to know how my 3NF tables could look in 0NF, 1NF and 2NF. For both the purpose of ensuring the database is correct now, and for...
  2. L

    Check Previous Orders

    Hey, I have an orders form, which makes the orders, but I would also like to be able to search back through old orders to append them in the same form. Currently I have frmOrders, which has a combo for the customersID (which then adds their details to fields). In this form I also have...
  3. L

    SQL query for Royalties

    Hi guys, I have constructed a database which is basically sales related. It is basically used for keeping tracks of Books, where the artist gets royalties. I want to, in the most logical way (perhaps a monthly report) be able to keep track of how much the Author of the book is owed. All of the...
Back
Top Bottom