T
Tony Williams
I am creating a database, for an organisation that has a number of
committees, to keep records of all the documents they produce eg minutes,
papers etc. There are also a number of sub committees and the documents are
to be identified with the main committees and any number of sub committees,
there could be upto 20, to whom they are relevant. I had envisaged that on
my input form I will have a tick box for all the committees and
subcommittees and the user ticks each
one that applies. However I then want to show a form, in edit mode, that
shows the committee that "owns" the document and lists any of the other
committees or
subcommittees that the document has gone to and leaves out the ones
that it hasn't gone too. I had envisaged having a table of committees and
sub committees and somehow linking the document record table to the
committee table.
If anyone can make sense of this can they suggest a way of accomplishing
this?
committees, to keep records of all the documents they produce eg minutes,
papers etc. There are also a number of sub committees and the documents are
to be identified with the main committees and any number of sub committees,
there could be upto 20, to whom they are relevant. I had envisaged that on
my input form I will have a tick box for all the committees and
subcommittees and the user ticks each
one that applies. However I then want to show a form, in edit mode, that
shows the committee that "owns" the document and lists any of the other
committees or
subcommittees that the document has gone to and leaves out the ones
that it hasn't gone too. I had envisaged having a table of committees and
sub committees and somehow linking the document record table to the
committee table.
If anyone can make sense of this can they suggest a way of accomplishing
this?