Jim Strickland Posted January 19, 2005 Share Posted January 19, 2005 I'm not sure if this is the correct forum or not. This problem seems to fit in several. We have a database called Spec Sheet. For each job that comes through our company a new record is created. This record gives all of the specifications for the new job. This was fine while we were doing mainly art jobs. Now we are also performing data pulls for customers. I have created a new layout in this file that will contain information specific to data jobs, versus art jobs. Here is my dilemma. Data contracts can have different terms. Some may be one time, some one year, 2 year, or three year. The update schedule could be different as well: One time, anually, semi-anually, quarterly, monthly, semi-monthly, or bi-weekly. I have a term field that is text format. I have an update field that is text format. I need to create a specific number of update dates based on the term and update schedule. For example: If The contract term is 2 years and the update schedule is quarterly, I need the layout to show 8 places where dates for each scheduled update can be displayed. Ideally, if I put in the first date, Filemaker will then, automatically generate the rest of the dates. Due to the fact that some term and update schedules could produce an unwieldy number of dates, I would probably only have the dates generated for quarterly, semi-annual, and annual pulls. Monthly, semi-monthly, or bi-weekly pulls would only show dates for the first pull and last pull. Is the above scenario possible? If so, is it possible to establish by a novice like me if given the necessary script steps? Would it be better to just manually create a set number of fields for update dates and just use the necessary number of fields for the chosen criteria? Link to comment Share on other sites More sharing options...
This topic is 6646 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 account
Already have an account? Sign in here.Sign In Now