use checkbox?

  • Thread starter Thread starter nyd
  • Start date Start date
N

nyd

I need to create a basic database, so that users can keep
track of progress notes on various clients. We might have
a meeting that will discuss various topics, some meetings
will discuss more that 1 topic.

I created a tlkp of the different topics, but how do i do
it, so if they discuss more than 1 topic, the user can
select more than one? I was thinking of a checkbox on the
form, but how would i set it up, so that it can keep track
of all the topics that were discussed?

I'm just starting to create this database, and so far I
have 4 tables

tbl1: client information (social security#, Name)
tbl2: date of meeting and progress note
tlkp1: duration (it will show how long the meeting lasted
ex. 1 hour, 1.25hours etc.)
tlkp2: topics of discussion
any suggestions, guidance is greatly appreciated
 
there are about 7 topics and it shouldn't change, but it
might change sometime in the future.
 
Back
Top