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.
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