Referencing Multiple Records a Once
So, we have a table full of client information and we want to reference it in another table. However, there are duplicates of certain clients in the first table but some of the info is varied in the d...
Forum Discussion
You are going to want to start with your data being correct in the first place. If you have contacts that are spread around multiple Record ID's then that is not a great place to be.
Is there anything else contained in the Clients table that is a required field that can be used to make sure the client is unique? Or are you only working with the default Record ID?
Is there anything else contained in the Clients table that is a required field that can be used to make sure the client is unique? Or are you only working with the default Record ID?