By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,469 Members | 1,028 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,469 IT Pros & Developers. It's quick & easy.

How to make a subform unbound total carry back to a table

P: 1
I have a database of supplies that when put together create a card product. I currently have a form that shows all card information, then a subform within it that allows you to add supplies needed. I have created a total price for the card in an unbound box, but I need to be able to move it to my main table to then be able to create an orders form for the assembled product being formed. Is this even possible, ive been trying to figure it out for weeks???
Feb 21 '20 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 2.5K+
P: 3,385

Welcome to Bytes!

To briefly answer your question, the answer is, "Yes, it is possible." However, I would recommend NOT adding that total to your Cards table.

If you have a Cards Table and a Supplies Table, with the Card Index as the Foreign Key in your Supplies Table, there is no need to total the cost and send it back to the Cards Table. Just use the inherent relationship and create a sum of all the supplies in your Queries, Forms and Reports.

This is a basic database principle that prevents future headaches.

Hope this hepps!
4 Weeks Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.