I'm writing a VB6 program with an Access database, and I've never worked
with Access with more than a single table. This is a program for ADL
(Activities for Daily Living), and I thought it would be nice to have the
functionality of clicking on a date that the tasks were changed, so that, if
the daily tasks were changed (three months down the road, maybe), you could
see the basic progress of the client. At the moment, I have two tables-one
with the client number, and the name, address, etc., and a second table with
the client number, the tasks required, and the date. If I do add the
functionality for looking up when the tasks required are changed, would I
need a third table, and, if so, what fields would be necessary in it, and
how should it be linked to either (or both) of the other tables. At this
time, I don't want to ask the owners of this business what they want this to
be like, as I am a client (no one likes to admit they need caregivers, do
they???!!!???) doing this on my own, and I'd like it to be a surprise.
Thanks for any help,
Allen Bennett
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar