1 Reply Latest reply on Apr 8, 2015 8:21 PM by philmodjunk

    Table relationship help



      Table relationship help


      I have 3 tables (key fields listed):

      -labor needs

      • date
      • assigned user ID


      • user id

      -users request off dates

      • date requested
      • user ID
      I need to create a table for a value list that will not show users that have requested to not be scheduled

        • 1. Re: Table relationship help

          You don't need another table. Your -users request off dates table is all that you need for your value list.


          LaborNeeds::Date ≠ UserOffDates::DateOff

          UserOffDates::userID = Users::UserID

          You can set up your value list to list values from Users but with "include only related values starting from LaborNeeds."