Table Relationships

[waterguy50]

I have started a project database and would like to create project logs that
are unique to each project, but the include a log type that would be used for
many projects. I would like to be able to create unique dated entries
(records) to each log. I need help in establishing the relationships between
the tables.

 

[Fred]

Hello waterguy,

Taking a guess at items that weren't explicitly stated in your post, how's
this:

(feel free to shorten my long explanatory table and field names)

Make a "Pojects" table

Include a ProjectID autonumber primary key (PK) field
Include fields for your "one per project" type info.

"ProjectLogItems" table (feel free to shorten)

Include a "ProjectID long integer field
Included a ProjectLogItemsID autonumber PK field
Include fields for your "one per log entry" type info.

Link "ProjectID in the 1st table to "ProjectID" in the 2nd table.

 

[waterguy50]

Fred,

thanks for your reply, let me provide a better explanation.

I want to keep a categorical log (prespecified type) for example preliminary
design and final design are two types. Each project would have each type of
log see below

P1 Log 1
P1 Log 2
P2 Log 1
P2 Log 2
and so on,

each record above could have multiple dated entries to track the unique
project log combination. I have tried many table relationships without
success.

Can you help?