chaserracer83
Aug 3, 2012, 02:29 PM
Hello,
I am trying to make a database in third normal formation. For the most part I understand 3NF, but have a question about how to setup a certain find of relationship in 3NF...
I have a transaction table. Within this table it keeps track of the purchaser and the receiver of the item in the transaction. The purchaser can be the recevier or they could be different people.
I feel like creating two separate tables (one for purchaser and one for receiver) is not correct. I was thinking the correct way would be to have one customer table, but I am not sure.
I am creating the database within Microsoft Access and it only allows me to create one link between two tables... does anyone know the correct way to set this up?
Thank you,
Chase
I am trying to make a database in third normal formation. For the most part I understand 3NF, but have a question about how to setup a certain find of relationship in 3NF...
I have a transaction table. Within this table it keeps track of the purchaser and the receiver of the item in the transaction. The purchaser can be the recevier or they could be different people.
I feel like creating two separate tables (one for purchaser and one for receiver) is not correct. I was thinking the correct way would be to have one customer table, but I am not sure.
I am creating the database within Microsoft Access and it only allows me to create one link between two tables... does anyone know the correct way to set this up?
Thank you,
Chase