Re: project track / log outstanding items list

Roger,
in reply to your query:
1) what if someone (contractor) wants to post, how's that done
2) what if you want to reply to a contractor's reply, how's that done
To avoid duplicates, please refer to my last reply to Bob. It should
be basically thru some kind of form or forms.

seems like you need to track who is doing it and when
that's right

with my design, the action list is your original post of what is
required, by whom, when
and the comments are a list of posts (by whomever) to accomplish this
action item
I don't know how the contractor accesses your system, but if they
login to windows, it is easy to captures the windows login
or to use ms-access login and its current user
the problem with setting up a 'thread' environment, where an id links
replies to an original post, it is hard to query up / down the thread,
thus my flat tblActionItemComment table

the same here, please refer to my last reply to Bob on common
'linear' (one post-replies!) table design.

Maybe I should use that design and give up the other option I was
considering.
But please explain then this 'per record' user level security and
corresponding form design.
NOTE that client and contractor ("posts" and "replies") do not use
exactly the same data, some are common ie same, the other are
different.
How to differentiate this then (form or forms /wrt to linear i.e.
common post-replies table) ?
Many thanks in advance.

.

Relevant Pages

  • Re: uer
    ... you can't refer to the ... >will have to put it in a standard module. ... been able to fiquire out how to do it from a query. ... >> I'm creating a query in design view. ...
    (microsoft.public.access.queries)
  • Re: LIKE in JOIN
    ... the TABLE2 url have 3 different formats so extracting the common ... Build the query with an inner join, ... NEVER attempt to open in design view after making ...
    (comp.databases.ms-access)
  • Re: Partial Intersection on Multiple Query Results
    ... It is an "unusual" design to have multiple tables with the same fields. ... saves you all the work of UNION queries. ... > I want to know the name setcommon to all the 8 query results. ...
    (microsoft.public.access.queries)
  • Re: How can I?
    ... You open a form (that you design) that will ask for the parameters and on ... launch the query that will refer to the form ...
    (microsoft.public.access.queries)
  • Re: Using a form to enter query parameters
    ... To refer to the control, open the query in design view. ... adjusting for the actual names of your form and controls. ...
    (microsoft.public.access.gettingstarted)
Loading