KenHigg
Registered User
- Local time
- Yesterday, 19:52
- Joined
- Jun 9, 2004
- Messages
- 13,327
Hi Tyler,
What is the difference between Owner and Employee?
About 3 zero's on their w2 -
Hi Tyler,
What is the difference between Owner and Employee?
I see no reason there could not be many entries in the documents table for each document, all having different version numbers. The document and version number make it unique.I would have to disagree on this if you want to track multiple versions of a document, not just have one version at any one time. There are reasons why you would do so. One example is the production illustration documents produced by Boeing. We needed to know which version of the P.I. was in what department at any one time, not just the most up to date version.
LOL Thanks Ken, I needed that this morning.About 3 zero's on their w2 -
I see no reason there could not be many entries in the documents table for each document, all having different version numbers. The document and version number make it unique.
I think you just moved your issues out to the Version table but I could be wrong. I think the question is "Does more than one version exist at the same time?" If not then your version table makes sense. Maybe I'm just all wet here.
You can put the table in the relationships TWICE - once to show the employee and once for the owner.
Hi Tyler,
What is the difference between Owner and Employee?
Are Owners also Employees?
About 3 zero's on their w2 -
Maybe this link will help a bit.I have put the employee table in the relationships window in an attempt to use it twice but failed to work out how to enter the joins to make the thing work. My frustration at the ambiguous outer joins error led me to start this thread!
Could anyone point me to an example of how to do this?
Thanks
Tyler
I thought that was the case. The "User" of the document and the "Owner" of the document are simply two ForeignKeys in your Document table that point to the Employee table. The two FK's can be the same if that is the case.Employees are users of the documents. The owners are the people who write the documents and the new revved up versions of the documents. They are employees too! Hence the duplication of information. The db works ok with two seperate tables but I recently had to update information on an employee who was also an owner, twice. Perhaps it would be easier to leave it as it is?
Thanks for your interest anyway.
Tyler
I thought that was the case. The "User" of the document and the "Owner" of the document are simply two ForeignKeys in your Document table that point to the Employee table. The two FK's can be the same if that is the case.
Agreed! I refer to Allen's site all of the time. I have it from a good source (Allen) then even he refers to the site often. Hope you get your issue sorted. Post back if you have more questions.Great reference site.
surely if you are keeping a document history, then the document versions belong with the documents. why does each version of the document need a different owner?