I’m working on a database that will have users and products.
I don’t want to have the products attached to the users to make the database more efficient, but I can’t seem to figure out how to pull the data from a Different table and display it on a user specific page.
For example, user is logged in, in a data field they have a model #, i want a text cell to look up that model number in a different table, and bring up the “features” field as an example.
I’ve been trying the “do a search for” functionality and can’t get it to display user specific data.
It simply posts the first result in whatever sorting order I tell it to.
Just struggling to learn what logic to use to get this done. Thanks.
Any ideas or suggestions?