CallumMascall
New member
- Local time
- Today, 14:51
- Joined
- Sep 18, 2020
- Messages
- 15
Hello, i am absolutely brand new to access and no basically nothing at all
I was supposed to do a unit on databases for my extended diploma in IT but i never got to learn anything because the virus shut my college down
Anyway, i am making a database system for the company i work for (agricultural company). On this database will be an order tracking system for parts we have ordered where i have a table for orders (tblOrders) with a unique order number. Then i have an order details table (tblOrderDetails) that will have the different parts ordered.
I have a 1 to many relationship set up so that the unique order number from tblOrders is assigned to each field from that order in tblOrderDetails
I have a subform set up in my main form so that you can enter multiple different parts and then when you submit it, you get a single order in tblOrders and all the parts from that order in tblOrderDetails. It kind of works, it adds them, but for some reason the order number is not being put in the very first field, after that every entry has the related order number.
Im fully aware ive jumped in the deep end.
Attached is screenshots of my form and the tblOrderDetail. As you can see the order number is "order" but is not there for part number 1234 (ItemID 11) yet it is forpart number 5678 ( ItemID 12)
Im very confused, very new to access and aware this is probably not explained very well, im not very good with all the technical words yet! Sorry!
I was supposed to do a unit on databases for my extended diploma in IT but i never got to learn anything because the virus shut my college down
Anyway, i am making a database system for the company i work for (agricultural company). On this database will be an order tracking system for parts we have ordered where i have a table for orders (tblOrders) with a unique order number. Then i have an order details table (tblOrderDetails) that will have the different parts ordered.
I have a 1 to many relationship set up so that the unique order number from tblOrders is assigned to each field from that order in tblOrderDetails
I have a subform set up in my main form so that you can enter multiple different parts and then when you submit it, you get a single order in tblOrders and all the parts from that order in tblOrderDetails. It kind of works, it adds them, but for some reason the order number is not being put in the very first field, after that every entry has the related order number.
Im fully aware ive jumped in the deep end.
Attached is screenshots of my form and the tblOrderDetail. As you can see the order number is "order" but is not there for part number 1234 (ItemID 11) yet it is forpart number 5678 ( ItemID 12)
Im very confused, very new to access and aware this is probably not explained very well, im not very good with all the technical words yet! Sorry!