title: Is it possible to force a relationship to be one-to-one instead of one-to-many? if not, then what?
body: <p>I have a database assignment due very soon and I am wasting a lot of time on the wrong things.</p>
  <p>To keep it simple, I have a table called Character that draws info from many tables, one of them being Inventory. Both Character and Inventory have a field called inventory_ID which is the PK in the Inventory Table.</p>
  <pre><code>SELECT gold, char_name
  FROM Inventory, Character
  </code></pre>
  <p>I tried to write a query to get the gold from every character, so instead of, for example:</p>
  <pre><code>character 1 : 200 gold
  character 2 : 500 gold
  </code></pre>
  <p>it shows:</p>
  <pre><code>character 1 : 200 gold
  character 1 : 500 gold
  character 2 : 200 gold
  character 2 : 500 gold
  </code></pre>
  <p>When making the relationships, I noticed that I cannot manually change the type. Most of the time, this is fine, but for this one, I think the problem is that Inventory has a one-to-many relationship with Character, thus making it so every character has one of every Inventory(?).</p>
  <p>I've been bashing my head in this for quite a while and time is running out, I didn't want to resort to asking for help, but I see no other option.</p>