I have a table with the following fields NewMessageId (pk) NewMessageText MessageInitiatedBy (fk) MessageSentTo (fk)
Both the messageInitiatedBy and MessageSentTo are foriegn keys relating to plumUser table. Is this legal? Is it still a one to many if there are two fields in the same record that relate to the same table? Thanks, Mark ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
