What about creating a self-join relationship with your Requests Table and setting Make = Make, Model=Model, and Budget ≤ Budget?
then, via a Portal, you will be able to view any Requests that exist already matching that criteria.
Thanks for your quick response.
My Machinery and Requests table are already related by means of a relational value list that doesn't have anything to do with this specific task. So when I tried to create a relationship between Category, Make, Model, etc. in the Machinery table to the corresponding fields in the Requests table, the error came up that I would need to make a separate table occurrence...
So if I want to include a portal on each record in the Machinery layout which would list any Requests that match its information, and a portal on the Requests layout that would show any matching Machinery items, how would I do so? Would I need to create a new table occurrence of both the Request and Machinery table and then link the fields from RequestCOPY to Machinery and from MachineryCOPY to Request? Or is there something else that I need to do?
Thanks in advance.