Search results

  1. C

    What is the solution to this primery key error?

    jdraw, you got a point. Zipfile is uploaded.
  2. C

    What is the solution to this primery key error?

    bestelregel (orderrule table) bestelnr = ordernr productnr = productnr aantal = number prijs = prijs persnr = staff_number bestelling (order table) bestelling = bestelnr tafelnr = table number besteltijd = ordertime medewerkernr = employeenumber totaalbedrag = total ammount tijdafrekenen =...
  3. C

    What is the solution to this primery key error?

    I have translated the database into English: to get the database working. A database is ready for download via (Dropbox) goo.gl/KI3aQs @plog: To be more specific the totaalbedrag means; the total sales amount per ordernumber (bestelnr) @sneuberg/@jdraw: Good advise; Dsum and to remove...
  4. C

    HOW do i calculate the total order price per ordernr ?

    I fixed the errors. How do i calculate the total amount per order? What sql or access changes do i undertake?
  5. C

    HOW do i calculate the total order price per ordernr ?

    HOW do i calculate the total order price per ordernr ? <img src="" alt="" border="0">
  6. C

    What is the solution to this primery key error?

    Thx. Follow the advise. Now i need to know how i automate the price when the ordertabel is submited, insted off manual input. This are my tabels and relationships. What do i change in the database to make this work?
  7. C

    What is the solution to this primery key error?

    What is the sosution to get the primery key work working? As far as i can see they are identical so what is cousing the error? en
Back
Top Bottom