What does your master supplier table have in it for columns?
When a user logs in, you have access to their login information (there are some caveats since you might have anonymous but in your case I doubt it).
So now you have everything available to the (page) for the Contact record they are logged in as, so you have their ID and Email Address etc.
So depending on what is in your Master Supplier list if you are not storing user specific details (so imagine you have 10 Contacts that are associated to that Supplier) you would either have look ups or a mapping/intersect table or using Connections.
So it depends on which you have. If its a 1 to 1 where in the Supplier table you store their email.. then you can simply use the logged in users email address to find the Supplier.
If you use connections it will be different and if you use Lookups between Contacts and Suppliers, then your query is slightly different
You are either (in my examples) using a Lookup that compares email addresses to find the master supplier record, or you are using the Lookups contact id, which you get from their login.
Can you explain what the logical and referential connection is between your master supplier table and the user who is logged in?
If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.
Thank you!
Sincerely, Michael Gernaey
