By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,573 Members | 3,008 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,573 IT Pros & Developers. It's quick & easy.

Main table and 32 Sub tables

P: n/a
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
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.