Is there any limitation on fields and instances when creating associations?

No, your dataset can contain as many number of fields and instances as you like.