Hello all. I hope someone has an idea for me:

We have a Job Info file that contains project Job Number, Start date, Ship date, estimated hours, etc. We also have a Calendar file that, when using portals and relationships, we had it pull the Ship Date for each job and place it on the correct day. (Our calendar is set up as 1 record contains 1 week)...

Also in the job file, using a FileMaker Tech Info article, we are able to calculate how many business production days we have (No Saturdays or Sundays) between the Start Date and the Ship Date. Using that number (say 10), we divide that by the estimated hours (say 400) to get hours needed per day to complete the project.

I would like to be able to take the working days between the Start and Ship date (say 1/1/2001

Hello again all...

I have accomplished what I was looking to do using portals and a relationship I still need some help with... Thanks for reading.

Jerremy