Re: Lookup Table Question...

2006-08-10 Thread Dan Buettner
Mark, can you provide a sample of a query you're currently using to retrieve data from this table / joining on this table? Also, how big is this table? It may not be worth your time to change things around as this is a very simple structure and should remain speedy even if it grows pretty large.

Lookup Table Question...

2006-08-10 Thread Mark Donovan
hello all this is my first post...I haven't been able to find a way to half my table size through a primary key relationship that can exist once. If I want to relate "person1 (id = 4)" to "person2 (id = 1)" I have have had good success with the following table below. However, if i