Return to FileMaker.com
Table relationship help
I have 3 tables (key fields listed):
-users request off dates
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."
Retrieving data ...