AnsweredAssumed Answered

Show which cars are in use

Question asked by jackmac on Dec 10, 2015
Latest reply on Dec 10, 2015 by 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

Outcomes