• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 39
  • Last Modified:

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.
0
Knightsman
Asked:
Knightsman
  • 4
  • 2
3 Solutions
 
Walter CurtisSharePoint AEDCommented:
This may be something that a SharePoint designer workflow could help out with.

Good luck...
0
 
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.
0
 
PatHartmanCommented:
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.
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
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.
0
 
KnightsmanAuthor 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.
0
 
KnightsmanAuthor Commented:
Was able to figure out a better approach to unanswered problem.
0
 
Walter CurtisSharePoint AEDCommented:
Thanks
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now