How To Create a MultiTable search?
Hi, I am creating an admin area. I want the owner to be able to look up 2 things:
the Dealer information from the user table
and the Order information from the Requests table.
ASFAIK, I have to create 2 separate sets of DataAssist search pages, one for each table, which seems odd and redundant. Is there a way to set up A data search and call up dealer info and their order info in one search or set of pages?
FYI, my orders are only requests for custom designed jewelry, not actual processed orders, so they aren't in cart. The dealer fills out his user ID from the user table and inputs a request which goes into the requests table...
TIA,
Jeff