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

    Show which cars are in use


      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?






      Using FM14 Pro Adv, Mac OSX