If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Table Relationships
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. -- waterguy |
#2
|
|||
|
|||
Table Relationships
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. |
#3
|
|||
|
|||
Table Relationships
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? -- waterguy "Fred" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|