Hi everyone,

I am confused. I have an emp table and a time sheet table. I have a pop up list in the time sheet table to show all the SS#'s in the emp table. The relationship between the two is that SS#.

What I want to do is create a pop up list that only shows the active employees from the emp table.(field name status) I have created a self joined relationship in the emp table with a global field that is a constant "active" called gActive. the relationship is gActive to status. I Then created a pop up list with "Use values from field". Using Emp:SSnumber and clicked "Include only related values starting from" Self Active. This works great if the record already exists but nothing pops up when I create a new record. I tried using "include all values" with Self Active::SS Number but that shows all records. What am I doing wrong?

Any help would be greatly appreciated.

Thanks

Put the global field gActive in your TimeSheet table and create a relation to Emp; TimeSheet::gActive = Emp::Status. The attached file demonstrates.

Emp~TimeSheet.zip

Works Great! Thanks