Hi
I think I have seen it done somewhere, but what it is called and how to do it access escapes me.
So I have a tblSources which has SourceID, SourceType, Page, and Issue with other fields. SourceType should have a value that determines what Issue is the FK of what (Book, Journal, Websitej. I could put in three fields, (JournalFK, BookFK, SiteFK) but with any record two should be null (That doesn’t feel right).
I know I got something messed up.
Thanks in adavance
Western Neil