How do I list all records in another table?
This should be easy to figure out but I can't seem to... suppose I have a Budget database, and I have a table for Purchases that holds detailed information about all my purchases. In another table I want a list of all these purchases with their corresponding prices, so I can do calculations with the total of all these prices in this table. Every time I create a new record for Purchases, I want it to automatically be entered into the 2nd table with its corresponding table. How do I do the relations for this? thanks!