Hi there, my name is Jenny and I am from South Africa. I am building a database for my company to control our consumable stock that is bought and issued in our workshops. We have a huge workshop with over 150 employees.
I have set up my database and tables and I am now trying to build a form with a subform for purchase orders / invoices for consumables that have been ordered, delivered and still on backorder (for part deliveries). However, in my form, the "order details" form somehow doesn't want to link to the main Order Form. So, when I add Item Details such as the Item and price and so on...it shows ALL of the items, and does not only display the specific items ordered on specific orders.
I have watched so many hours of video trying to get this right, but to no avail. I'm sure that it is just a stupid little thing...but, please tell me what I'm doing wrong!
If anyone can just give a little advice or guidance, I will be eternally grateful.
Have a lovely day ☺