Order to delivery?!
Hi im making a database to log stock comming in and out of the business but im abit stuck now.
I have got creating an order and entering the order items in fine - the problem im now having it so once the item has arrived as a delivery i need to assign a delivery id to each item. Currently in my deliverys form, i have a list of un-delivered items, and i simply change the status from "Order" to "Stock. Once this change happens i want it to stamp that item with the delivery id (deliveries hold all the invoice and date info).
Ive attached an image below of relationship, if you can help please do.