I have a business requirement that I am trying to solve using lookup lists.
A business unit in my company deals with machine rentals and prints off a monthly report of all machines as well as the last update dealing with that machine for that month. If the machine wasnt used, the field is blank.
All of this is being done with a lot of manual steps and excel spreadsheets. I am trying to replace this using some lists in sharepoint but am a little lost how to proceed.
So far I have a list that is used as a lookup list that contains all of the information about the machines that can be used. I also have a list that contains updates, so you select the machine via the lookup field, fill in the extra information and save it.
Is there a way to like a sql join on the two lists? Have all machines from the lookup list displayed as well as the information from the most recent update written out?