Table Relationships

  • Thread starter Thread starter waterguy50
  • Start date Start date
W

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.
 
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.
 
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?
 
Back
Top