I own a pet store and I want to upload information about each of our pets customers, sometimes a customer have more than one pet.
So my idea is the following: the database is filled and updated by the administrator, because of that I can’t connect using the ID of the member nor the owner, in adition I want to conect a member to one or more entries in my custom database.
So as my logic goes it would be better to conect the database and the memeber using the Email of the member with an email field, is this possible? also how would be the workaround deciding which entrie is showing? using a dropdown?
In addition, I suggest, that the query field will be based on the user’s ID and not email.
Using ID is more correct way to base your query function on, since its a unique field and that way, you can be sure that the result you get is genuine.