Question at beginners-level..
I need to log people's medicine usage and now I'm stuck with my database-design.

This is the situation :

Table: User
UserID
Username
..

Table: Day
DayID
DayMemo
..

Table: MedicineDetail
MedDetailID
Dosage
..

Table: Medicine
MedID
MedName
MedUsage
..

There is a many- to many relationship
between Table.Day and Table.Medicine.
(using Table.MedicineDetail)

Table.Medicine is a list of medicine names and brands.
Now, in this design there is only one list for all users, but I need a unique
list of medicine for each and every user.

How can I best do this?
Thanks in advance.

Mark.

You need a many to many relationship between the User table and the Medicine table.

So in create a UserMedicine table that contains UserID and MedID.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Here you can find presentation about good database design.Hope it will help you
www.stral.in/downloads/Presentations/database%20design.pps