I have a main table and 32 sub tables linked to the main table.
In those 32 tables i store info, one of those infos is :
wether it is oke ( green - i store a number 3- ),
wether it is not oke( - i store a number 2 -),
wether it is alarm - i store a number 1).
I also store the date of entry because on my main form only the latest
entry is shown.
On that main form I would like to see for each ID_main table how many
Red, Yellow and Green entries there are in total over those 32 tables,
for the latest entrys.
Anyone, Anywhere, Anyhow, Anytime, Anything, Anyway TX
In those 32 tables i store info, one of those infos is :
wether it is oke ( green - i store a number 3- ),
wether it is not oke( - i store a number 2 -),
wether it is alarm - i store a number 1).
I also store the date of entry because on my main form only the latest
entry is shown.
On that main form I would like to see for each ID_main table how many
Red, Yellow and Green entries there are in total over those 32 tables,
for the latest entrys.
Anyone, Anywhere, Anyhow, Anytime, Anything, Anyway TX