Hi All,
I'm making an Access Web App in Office 365, which will be used to store technical documentation about our customers. My challenge is that I want to use data from multiple databases to narrow down a lookup field.
For example:
I have a table with Customer information. (CustomerName being the one I use for Lookup)
I have a table with locations, cause some of our customers have multiple branch offices.
I have a table with Devices (like routers and switches and firewalls)
What I really would like is when I'm adding a device, I first enter the CustomerName (lookup) and then add the location (2nd lookup) and then add all the relevant information of the device. (devicetype, model, config etc)
I have all this working, but the 2nd lookup shows ALL locations, also those from other customers. Is there a way to make the 2nd lookup field dynamic to only show/search for the locations which are associated with that specific customer?
I hope I explained it well enough for you all to understand, since I'm Dutch and not English.
Thanks in advance,
Lucas
I'm making an Access Web App in Office 365, which will be used to store technical documentation about our customers. My challenge is that I want to use data from multiple databases to narrow down a lookup field.
For example:
I have a table with Customer information. (CustomerName being the one I use for Lookup)
I have a table with locations, cause some of our customers have multiple branch offices.
I have a table with Devices (like routers and switches and firewalls)
What I really would like is when I'm adding a device, I first enter the CustomerName (lookup) and then add the location (2nd lookup) and then add all the relevant information of the device. (devicetype, model, config etc)
I have all this working, but the 2nd lookup shows ALL locations, also those from other customers. Is there a way to make the 2nd lookup field dynamic to only show/search for the locations which are associated with that specific customer?
I hope I explained it well enough for you all to understand, since I'm Dutch and not English.
Thanks in advance,
Lucas