Newbies hve Posted January 21, 2001 Newbies Share Posted January 21, 2001 I have an 'Employee Leave Record' file which fields appear in a 'Employee Records" portal. I want to be able to limit the records appearing in the portal to a certain year. Right now all related fields to the parent record appear in the portal and I want to have the option of only seeing records for a specific year. Link to comment Share on other sites More sharing options...
Chuck Posted January 21, 2001 Share Posted January 21, 2001 I'm assuming that the relationship is based on an Employee_ID field of some sort. Create a field in your Employees database that is a text calculation: Employee_ID & "-" & Year( Status( CurrentDate ) ) Create a field in your Employee Leave database that is a text calculation: Employee_ID & "-" & Year( Date_To_Base_Portal_On ) Then relate these two fields and view that new relationship in the portal. Chuck Link to comment Share on other sites More sharing options...
Newbies hve Posted January 21, 2001 Author Newbies Share Posted January 21, 2001 Thanks for the VERY quick reply! I will try your suggestion. Link to comment Share on other sites More sharing options...
Newbies hve Posted January 21, 2001 Author Newbies Share Posted January 21, 2001 Could I make the YEAR(status(currentdate)) portion of the concatenation a gobal field with pop up menu for different year selections? [This message has been edited by hve (edited January 21, 2001).] Link to comment Share on other sites More sharing options...
LiveOak Posted January 22, 2001 Share Posted January 22, 2001 Yup! Should work just fine. -bd Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8495 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now