netcode Posted January 30, 2009 Share Posted January 30, 2009 Hey all, I am working on a field that I want to hold the active years of a contract (ex. 2008, 2009, 2010,.. etc). I created a repeating field and I am looking to show or hide the repetitions based on weather the previous repetition is full. Is this possible? I have read about using a portal technique to show and hide fields but I having a tough time understanding that method and how I could apply it to this situation. Is there some sort of simple function to modify object properties? Thanks Link to comment Share on other sites More sharing options...
mr_vodka Posted January 30, 2009 Share Posted January 30, 2009 What is the purpose of this? Using a repeating field may not the most correct way to handle this. Link to comment Share on other sites More sharing options...
netcode Posted January 30, 2009 Author Share Posted January 30, 2009 The general purpose of this field is to store the active years of the contract (ex. 2008, 2009, 2010) Link to comment Share on other sites More sharing options...
bruceR Posted February 4, 2009 Share Posted February 4, 2009 You are experiencing a problem directly caused by using repeats. Get rid of the repeating fields; use a portal and related table. Link to comment Share on other sites More sharing options...
netcode Posted February 4, 2009 Author Share Posted February 4, 2009 It looks like that really may be the best solution, despite if I want that to be the solution or not :) Link to comment Share on other sites More sharing options...
aholtzapfel Posted February 4, 2009 Share Posted February 4, 2009 (edited) Depending on your needs, you might try somthing like this. (Calculation based on contract dates, Start and End, see attached file. I only made this work for contracts up to 6 years long.) Finds should let you enter one year and find all jobs active for that year. Relationships will also work using this as a key field. ContractYears.zip Edited February 4, 2009 by Guest Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5531 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