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

    Table relationship help

    ericjlindholm

      Title

      Table relationship help

      Post

      I have 3 tables (key fields listed):

      -labor needs

             
      • date
      •      
      • assigned user ID

      -users

             
      • 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
          philmodjunk

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

          LaborNeeds----<UserOffDates>----Users

          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."