Table Relationship by day

  • 0
  • 1
  • Question
  • Updated 10 months ago
I have a table where all employees have an overtime record for everyday of the year. I want to have a second table where I will have vacation requests for each employee. There will be just one request per day but not every day. When an employee overtime record is being looked at, I need to know if they have a vacation request for the one day in question. How would I set up that relationship?
Photo of Marc Nelson

Marc Nelson

  • 322 Points 250 badge 2x thumb

Posted 10 months ago

  • 0
  • 1

Be the first to post a reply!