Search results

  1. J

    Learning Normalisation EMS as Sample

    hi guys! normalisation again. is this normalised? thanks?
  2. J

    Learning Normalisation

    jdraw, how about this? https://www.lucidchart.com/invitations/accept/cdbfd94e-7bc4-43bf-bbf2-5f69c8b848d5
  3. J

    Learning Normalisation

    jdraw, oh i get it! thanks! so i need to create another table that would link to deliveryDetails. and the deliveryDetails would have a status of delivery?
  4. J

    Learning Normalisation

    jdraw, the items in delivery details are in order table down to orderDetail. is that the right relationship to do? selling price - yes i must include that
  5. J

    Learning Normalisation

    free of course!:D
  6. J

    Learning Normalisation

    jdraw, i think it's the shipment_items. it can cater several items and shipment in 1 invoice ID. anyway. with that as guide. is this new revision close to that? Thanks!
  7. J

    Learning Normalisation

    jdraw, why does it have a table of shipment items? can't it just relate directly to orderItems and Shipments? Thanks!
  8. J

    Learning Normalisation

    @jdraw Thanks! I'll check on it
  9. J

    Learning Normalisation

    @Steve R. Thank you for having a time to reply/suggest/recommend :) i have downloaded the book and will try to study it out. really appreciated! [orderID] - it's an Autonumber. it cannot be changed [product] - can be supplied by many supplier with different prices and unit. so i created a...
  10. J

    Learning Normalisation

    @ridders, nope. it's in here https://www.lucidchart.com/documents/edit/df7aa38c-0031-454b-a328-ae423cfb3375
  11. J

    Learning Normalisation

    to clarify the [type] in Table Orders
  12. J

    Learning Normalisation

    is it proper to put a cost in delivery details? why order details has no cost?
  13. J

    Learning Normalisation

    @ plog i know very little about this stuff. so please bear with me..:p with question i think i need the details in delivery because if i don't have a details then what will answer the question "what to deliver?" yes. i may order 5 items, 2 of which i decide to be delivered and 3 i'll just...
  14. J

    Learning Normalisation

    i'll get back tommorow
  15. J

    Learning Normalisation

    should i use insert or can we just properly create a reference/relationship between orderDetails and Deliveries?
  16. J

    Learning Normalisation

    how do handle this delivery table? the customer should of course buy first a product before he can have a delivery. how do you do that in user form? Thank you.
  17. J

    Learning Normalisation

    here is the tables and relationships in access all good? if yes, i'll populate it with data. then create a form.. then i'll post it again here. the problem i see here is in linking the details. order and delivery to their appropriate tables.
  18. J

    Learning Normalisation

    just for my learning (refreshing).. i've not coded for a very long time.. getting dull i think.:banghead:
  19. J

    Learning Normalisation

    i will now proceed in access. then i hope you can follow along. just to guide my confused mind. :D i'll first create the table and it's relationships then i'll post it again. thank you! :)
  20. J

    Learning Normalisation

    oh yeah! :) seen it. all good now?
Back
Top Bottom