Associating multiple data with a single entry in Open Office Base
Posted
by idyllhands
on Super User
See other posts from Super User
or by idyllhands
Published on 2010-06-06T04:35:26Z
Indexed on
2010/06/06
4:42 UTC
Read the original article
Hit count: 539
openoffice.org
|database
I'm trying to build a database that I can use to track prices of groceries on certain dates. My problem is that I cannot figure out how to have a single entry associate with multiple data. For example, carrots. The index would be carrots. Then, a few categorizing fields (ie, Produce|Vegetable) Then, I can enter a price, date that the price was valid, store that was selling for said price, etc. And the next time I buy carrots, I can just add a new set of pricing data that would be associated with the original carrots entry. I know very little about database building, so if anyone has something I could just modify, I would greatly appreciate it. Alternatively, a step by step tutorial would be great.
© Super User or respective owner