Three Questions

[sparklegrrl]

I have 3 questions that I can't figure out.

#1) I have a custom menu created. How do I set it to open a form empty instead of having the 1st record fill in. I know how to do that with the switchboard, just open in add mode but I can't figure it out with the mnau.

#2) I would like for a graphic to appear somewhere on a form if the job cancelled field is populated. Is there a way to do that?

#3) This is the big one. I have a work orders table. Within it are these fields,

Car No (number field)
Trailer Number (text field)
ScheduleBlast (date field)
ScheduleCement (date field)
SchedleLining (date field)
ScheduleCuring (date field)
ScheduleInspectandShip (date field)

I need to somehow make a pivot table that kicks out this report

I assume the car no, & trailer no should be the data fields and the blast, cement, lining, curing and ship should be the rows.

How do I make it put the dates across the top and run the report on a weekly basis as above?

Did I not set the table up right? I can NOT figure it out for anything.

Thanks for your help.

 

[sparklegrrl]

So, should I move the operation type and the schedule date into a different table?

Otherwise, do I need 5 operation dates?