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

Filed under:
|

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

Related posts about openoffice.org

Related posts about database