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

[wells0587]

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???

[twinnyfo]

wells0587,

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!