I'm using Access 2010 to create a budget database. I'm trying to create a form so that users can enter a single record that can allow multiple values. For example, if someone goes to a supercenter such as Target or Walmart, they may purchase items that fall into multiple categories such as groceries, clothing, toys, etc. I'd like the form to accept a single record that includes date, check # (if applicable), etc., then allow the user to make multiple entries of amounts and expense categories, and have Access track the total amount for that specific record.
Is this possible? And if so, how is it accomplished?
Thanks in advance if anyone has any ideas.
Doug
Bookmarks