Search results

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

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

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?

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

free of course!:D

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!

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

@jdraw Thanks! I'll check on it

@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...

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

to clarify the [type] in Table Orders

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

@ 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...

i'll get back tommorow

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

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.

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.

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

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! :)

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