Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Calculate future dates based on 1st date within related reco

 
   Database Help (Home) -> FileMaker RSS
Next:  When Snapshot applied in Subscriber?  
Author Message
Carrielee




Joined: Sep 08, 2009
Posts: 1



(Msg. 1) Posted: Tue Sep 08, 2009 3:17 pm
Post subject: Calculate future dates based on 1st date within related reco

I am working on a database for clinical trials having tables for Patients, Trial info, Patient in trial and then Services. (other tables not important here.)

Patients in trial table uses the Patient ID and the Trial/study ID as forgeign keys. This sets up each patient within a specific trial since patients may be in one or more trials. Services is a child of Patients in trial and lists the many followup dates and services done within the study. If all patients are seen at the same timepoints (day 1, day 15, day 30....for example) how can I calculate this so that the future dates will automatically enter as new records once I enter the first service date for each patient?

 >> Stay informed about: Calculate future dates based on 1st date within related reco 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Find based on a date field in FM 6 - I am trying to write a find script that finds records that have a date field in between two given dates. i.e: I have a file with a date field named DATE and two other global date fields named FROM_DATE and TO_DATE. I want a script that finds all record...

60 days future or past - Hi, I remember this newsgroup help me long time ago, that I use Filemaker pro 4.0. I am using Filemaker 8.0 right now. Field: ExpiredDate Search today to 60 days future (current date) + 60 days Search today to 60 days past (current..

Working with related records - HI, I am new and I need some help. I am building a case management database that has related links to several other databases. From my main input page I have a button to go to a related file and it only finds related tables to the record I had up when I....

Related Notes script - I have a CONTACTS table. I want to create a button with a script that takes one from the current Contact to a related record called Notes. The objective is an easy reference page of communications notes. I was thinking that I should create a new table..

creating related record by script - when you create a record in a portal, the good value for the linked field is automatically filled. How can you make this with a script, without a "set field" in the linked field ? -- www.D-L-S.org
   Database Help (Home) -> FileMaker All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]