3 Replies Latest reply on Dec 10, 2015 3:40 PM by jackmac

    Show which cars are in use

    jackmac

      Hi all,

       

      My client has 20 staff cars. They want to show on a grid which cars out out and which are available. I had figured a grid system which is colour-coded (conditional formatting) but am struggling with the correct method.

       

      I have a table for cars.

       

      There's a Car ID field and a Car In Use field. Car ID is numeric, Car In Use is Yes/No.

       

      I'd like to create a grid which shows say a square which is coloured red if 'Car ID=1, Car In Use=Yes'. There would be 20 boxes which would be on a 5 wide, 4 high pattern so I can't use a list format.

       

      Any suggestions please?

       

      TIA

       

      Jack

       

      Using FM14 Pro Adv, Mac OSX