RammerJammer1674
Registered User.
- Local time
- Yesterday, 23:04
- Joined
- Jan 2, 2013
- Messages
- 18
Hi everyone,
I'm building my first ever database and need some help. I've created a Multiple Items Form called PurchaseOrderLineItems, and it is being used as a subform. It comes from a Table called Purchase Order Details. My columns in the form are Manufacturer, Model#, Description, Quantity Ordered, Quantity Received, Unit Price, and Extended Price.
It's Primary Key is just ID since that does nothing.
Manufacturer is pulled from a table called Manufacturers. Model # is pulled from a table called Items which has a lookup for reference the Manufacturer. Then, the Description, Unit Price, and Extended Price should be referenced from the Model # which also comes from the Items table.
Now, I set this all up from my record sources, and that's when it gets screwy. Say I have 3 records with only 3 different manufacturers. The model# combo box will only show what has been queried for the entire form, not what is on each record. Example: I have Manufacturer A with Model #s 1, 2, 3, 4, and 5.
Manufacturer B with Model #s 6, 7, and 8.
Manufacturer C with Model #s 9 & 10.
If I select Manufacturer A for my first record, my Model #s will come up as 1, 2, 3, 4, and 5 in my combo box. That is correct.
Then for my next record, I select Manufacturer C. I have a Refresh Macro after update for this, so the Model #s will come up as 9 & 10. That is correct also. However, if I need to go back to the first record and change those model #s, they will show as 9 & 10 which is not correct at all. Any suggestions?
Please keep these as entry level responses, I'm doing good to have what I've done so far! LOL
If I need to upload my database I can. Just let me know.
I'm building my first ever database and need some help. I've created a Multiple Items Form called PurchaseOrderLineItems, and it is being used as a subform. It comes from a Table called Purchase Order Details. My columns in the form are Manufacturer, Model#, Description, Quantity Ordered, Quantity Received, Unit Price, and Extended Price.
It's Primary Key is just ID since that does nothing.
Manufacturer is pulled from a table called Manufacturers. Model # is pulled from a table called Items which has a lookup for reference the Manufacturer. Then, the Description, Unit Price, and Extended Price should be referenced from the Model # which also comes from the Items table.
Now, I set this all up from my record sources, and that's when it gets screwy. Say I have 3 records with only 3 different manufacturers. The model# combo box will only show what has been queried for the entire form, not what is on each record. Example: I have Manufacturer A with Model #s 1, 2, 3, 4, and 5.
Manufacturer B with Model #s 6, 7, and 8.
Manufacturer C with Model #s 9 & 10.
If I select Manufacturer A for my first record, my Model #s will come up as 1, 2, 3, 4, and 5 in my combo box. That is correct.
Then for my next record, I select Manufacturer C. I have a Refresh Macro after update for this, so the Model #s will come up as 9 & 10. That is correct also. However, if I need to go back to the first record and change those model #s, they will show as 9 & 10 which is not correct at all. Any suggestions?
Please keep these as entry level responses, I'm doing good to have what I've done so far! LOL
If I need to upload my database I can. Just let me know.
