AnsweredAssumed Answered

Outstanding Vessel Script Help

Question asked by schnook on Oct 25, 2011
Latest reply on Oct 26, 2011 by schnook

Title

Outstanding Vessel Script Help

Post

HELLO ALL

WE HAVE A VESSEL LOG ON DATABASE THAT THE GENERAL PUBLIG CALL US AND LOG ON FOR THE DAY,

THE FIELDS THAT WE USE ARE

FROM=VESSEL REGISTRATION,

FISRT LOG IS A VALUE LIST THAT CONTAINS YES & NO,

CLEARED IS ALSO A VALUE LIST CONTAINING YES & NO.

NOW SOMETIMES A VESSEL CAN HAVE 4-6 ENTRIES FOR THE DAY

EG: WHEN THE VESSEL FIRST MAKES CONTACT FIRST LOG = YES, CLEARED = NO,

THEN ANY OTHER ENTRIES THAT THEY ARE NOT SIGNING OFF CONTAIN FIRST LOG = NO, SIGNED OFF = NO,

NOW WHEN THEY DO SIGN OFF FOR THE DAY FIRST LOG = NO, SIGNED OFF = YES

NOW WHAT I WOULD LIKE TO DO IS TO CREATE A BUTTON WITH A SCRIPT THAT WILL ONLY SHOW VESSELS THAT HAVE NOT SIGNED OFF, BUT ONLY THEIR LATEST ENTRY THAT SIGNED OFF = NO, IN A TABLE VIEW FORMAT.

CAN SOMEONE PLEASE IN DUMMY TERMS HELP ME WITH THIS.

WE ARE RUNNING WIN 7 WITH FMP ADVANCED 11

REGARDS

SCHNOOK

Outcomes