Sure... this is a single table, "MFG SOPs." A single records for each of our suppliers utilized by our Item and Cost Maintenance Group. It's a glorified spreadsheet in that one person on the team has the ability to edit, while the balance of the team can view records only. The initial excel file simply had a tab for the data manager, and another for the team to use in which they entered a MFG Code and a series of vlookups pulled over the data onto the "form." The issue is that over time it has become a very large excel file and was cumbersome to both edit and share.
In rebuilding it I'd like to try and keep the easy type in MFG Code interface with the team at large, and from the Dashboard I just use the quick built in table search feature and use an exact match. That brings me right to the data form in view only mode for the team. PERFECT!
But if I create a report in which I specify the user to select the MFG Code (from a list of 60k+) it kicks into a report first for them to have to click and view the form. Not a big deal I suppose, but it's an additional step. Additionally, I'd love to embed something like the Dashboard built in search in the form for them to find another without having to exit to the table's default report.
