Access 2016 Web App for Sharepoint update field based on first field data

Trying to figure out how to make a field populate based on another field which is a lookup field.  

So I have a "part loaner" that looks up "parts list".  Parts lists has a "Coalesce([Device]+" "+[Make],[Model Number])" Field, and I want the Parts loaner List to populate the "Coalesce([Device]+" "+[Make],[Model Number])" when the user enters in the parts lists ID part ID.
Who is Participating?
KnightsmanConnect With a Mentor Author Commented:
I realize now, that I can set the field from the main inventory to show the corresponding cell under the datasheet.  It wont help the individual but takes care of my need to know what the piece is.
Walter CurtisConnect With a Mentor SharePoint AEDCommented:
This may be something that a SharePoint designer workflow could help out with.

Good luck...
KnightsmanAuthor Commented:
Seems its not available when creating an access app.  its very restricted.  Although I guess I could make a desktop version and use it and possibly copy it over, not sure that will work, but its a good idea.
7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

PatHartmanConnect With a Mentor Commented:
Why would you want to copy the data from one table to another?  That just duplicates the data.  You could always get the current value by using a query that joins the two lists.
KnightsmanAuthor Commented:
I have an inventory database, and with that, a Part Loaner Tracker the user will enter the "item number" based on the inventory number on the piece, and I want it to populate the description of the piece so they can verify its the right part.  It also saves me from having to go to the other list, to figure out what it is they have loaned out.
KnightsmanAuthor Commented:
Was able to figure out a better approach to unanswered problem.
Walter CurtisSharePoint AEDCommented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.