i have a layout that i am completely stumped on...

i need scripts to do everything show on this makeshift lay out:

http://img18.imageshack.us/img18/7117/help7we.png

i know how i am going to do the sorting to populate the production feet fields...but i don't know how to do the dates at the top, and i think i can handle the caclculation fields with the +/-

can anyone think of a better way to do this or help me in doing it this way...

btw i will be using chartmaker to make the charts...unless V8 has one in it

Edited September 6, 200520 yr by Guest

FMP holds dates as a number (internally), and these are sequential. Todays date 10/05/2005 = 732199, tomorrow will be 732200. If you set up some calc fields as numbers, eg.

Date_As_Number (Type NUM) = Date (Type DATE)

then you could use the calc fields to do the necessary maths.

Dates can also have simple maths performed, eg Date + 7 gives "one week today".

Only some pointers, HTH