My original thought was to have a specific table with which to draw all my phone number look ups from without needing to look at different tables depending on the...

I know there are ways to run comparisons on Word documents, but I personally haven't played around with it. You may want to spend some quality time with your favorite...

Depending on the types of documents being edited you could store the original copy of a file in a table. Then in another table contain records that only store the...

Chirag (1/21/2008)

Well your design is certainly a bit different from the usual way of doing things, but i reckon its a good design.

Do keep in mind the type of queries...

Thank you for posting Ian.

The issue is that a Customer or a Vender could have multiple phone numbers you need to keep track of. I need to know my vendors...

Hmm Russell, I think I someone misread your original intent. While your implementation would give one more table the number of entries are very limited. Wonder if there is a...

Yes I had thought about that, but it gives me an extra table I think, unless I am miss-reading your post. Also I can't directly foreign key the information.

Would be...