1 Reply Latest reply on Jul 20, 2010 12:29 PM by philmodjunk

    Pushing information to other databases



      Pushing information to other databases


      Here is a tough one.  Several people are maintaining schedules of stuff (a highly technical term) on their own desktop systems. Individuals can have as few as ten records, or hundreds of records they are tracking, each with it's own start and end date.  A central schedule exists on a separate system that has the complete set of records for everyone.  How do I set things up so that when someone enters a starting and ending date in a record on a local system those dates are automatically entered into the related record on the central schedule.  We are all using Filemaker Pro 10 and 11.  We are a combination of Mac and Windows.

        • 1. Re: Pushing information to other databases

          All the data for your schedules should be kept stored in the central schedule--not on individual workstations. Is the central schedule a filemaker database? If so, it should be hosted over the network and your clients should connect to it to find the schedule records that apply to them.

          When searching records by date--assuming the date is entered in a field of type date--you can enter find mode and enter the dates in this format: 1/1/2010...1/31/2010. On systems that use MM/DD/yyyy format, that finds all records from the month of January of this year. You can build such requests in scripts as well if you want to automate the search for records in a given date range.