Conditional Format
Conditional Format record set field
Displaying a set of records showing items on sale
Have a linked table showing item average and min price
tables
on_sale s,
price_history h
record set
s.Item, s.desc, s.size, s.price, h.avg_price, h.lowest_price
I would like d.price field to be red if lower than the p.lowest_price or blue if lower than the p.avg_price
Can you show me how to do this
thanks