title: Create a relationship across multiple tables that allows only one entry per date
body: <p>I am trying to create a database that will be used by multiple teams in my company that displays their daily stats. </p>
  
  <p>When you open up the database I have a combo box that allows you to select your team name. Once you make your selection, your form appears with your team stats for the day. (In reality it's just one form that has a subform with a query. The query is updated when you select your team from the combo box)</p>
  
  <p>Each team has their own separate set of stats for each day and they are only allowed one entry per day. Not every single team has the same category of stats. This is an example of some of my tables</p>
  
  <p>Quality Stats Table:<br>
  <strong>Team Name | Daily # | Actual # | Goal # | DateOfEntry</strong></p>
  
  <p>Productivity Table:<br>
  <strong>Team Name | Percentage | DateOfEntry</strong></p>
  
  <p>Stop Ship Table:<br>
  <strong>Team Name | Yes/No | DateOfEntry</strong></p>
  
  <p>How do I make it so that each team can only have one entry in each table per day?
  I have my Team Names linked across all the tables, but I am having a hard time enforcing the one entry per date restriction  </p>
  
  <p>I am very new at access and I am still trying to figure it out. I would greatly appreciate it if someone can point me in the right direction</p>