One to many not an option. Telling me I have to use many to many

[ChannelDevMike]

The ids in accounts table are unique. They corralate with the contacts table. One Id from accounts table can have the same Id 3 times in the contact table. It wants me to do a many to many relationship only and I dont understand why. 

[ChannelDevMike]

Unless multiple empty values from the accounts table through it off.. If so, how would I correct this?

[Smalfly · Accepted solution]

Hi @ChannelDevMike ,

multiple null values in accounts would indeed force you to use a many to many relationshipt between tabels.

You need to ask yourself whether:

1. it makes sense to have multiple empty account ID's in the situation you are in
2. you need those null accounts in your report

If you don't need the null accounts, you can delete them during data transformation.

If you do need them, your best option seems to create a new & unique account ID, then add that ID to your contacts table so that you can have a one - to - many relation between the 2 tables.