Dealing with sports events, 2 issues I have questions with, venue name changes and on a similar vein, competitor name changes. Female golfers (Dottie Pepper and Dottie Mochrie for example) played events in different years under different names. I want to be able to list the event and refer to the golfer but not have to list as 2 people, or sports venues that may change names but remain the same facility. What is he best way to set this sort of thing up?
Adam Schwanz
@Reply 4 years ago
I would probably make an Alias table and link it to them.Customer Dottie Pepper and then link her CustomerID to an Alias Dottie Mochrie. Assuming they have multiple names, if it's a name CHANGE permanently (marriage or something) I would probably just change the name in the customer table and move on, if you really had to store that old information I'd store it in a seperate field.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
TechHelp.
