AnsweredAssumed Answered

Secondary Instance of Table.

Question asked by TTiger on Jun 8, 2009
Latest reply on Jun 10, 2009 by TTiger


Secondary Instance of Table.




WHat affect will creating a secondary instance of a table have on my database? What I have set us An Events, Visitors, Participation, and Payment Table. Payment table has two keys, VisitorID and EventID. Using those ID's I have it set to lookup the visitor name and the event title when an ID is specified in the Payment table. In order for me to use the same lookups in the Participation table it made me create a secondary instance of the participation table in order to use VisitorID and EventID as keys. Will there be any affect on my database by having two instances of one table?