AndrewFry
6 years agoQrew Assistant Captain
Adding Location Map on Parent Form
Morning, Afternoon, and Evening everyone.
I have three tables:
Relationships:
Work Orders < Locations
Subdivisions < Locations
Subdivisions < Work Orders
When I create a new Location in the Location table via the Location form, once there is an address in the Address Field, it populates a map of the location, even before saving the record.
I am assuming that it is because it is an Address Field and it is built to do that.
In my Work Orders form, I can select the Subdivision, then the Locations record picker will only give me a list of the locations associated with that Subdivision, based upon conditional formatting.
However, when I select the Location, no map populates in the Work Order form.
I am assuming it is because the Location field in the Work Orders form is a lookup field conditionally built upon the Subdivision selection.
I have found a way to have a map populate once the record is saved, but not after selecting the location and prior to saving the record.
Is there a way to have the Location field in the Work Orders form behave like the Address field in the Locations form, and show a corresponding map prior to saving the record?
Here is an image of the map in the Locations' form. It is visible before even saving the record.
Here is an image of the location from the Work Orders form but not showing the map, even if the location is selected, before or after saving the record.
Your thoughts, input, suggestions, recommendations, are much appreciated!
------------------------------
Andrew
------------------------------
I have three tables:
Relationships:
Work Orders < Locations
Subdivisions < Locations
Subdivisions < Work Orders
When I create a new Location in the Location table via the Location form, once there is an address in the Address Field, it populates a map of the location, even before saving the record.
I am assuming that it is because it is an Address Field and it is built to do that.
In my Work Orders form, I can select the Subdivision, then the Locations record picker will only give me a list of the locations associated with that Subdivision, based upon conditional formatting.
However, when I select the Location, no map populates in the Work Order form.
I am assuming it is because the Location field in the Work Orders form is a lookup field conditionally built upon the Subdivision selection.
I have found a way to have a map populate once the record is saved, but not after selecting the location and prior to saving the record.
Is there a way to have the Location field in the Work Orders form behave like the Address field in the Locations form, and show a corresponding map prior to saving the record?
Here is an image of the map in the Locations' form. It is visible before even saving the record.
Here is an image of the location from the Work Orders form but not showing the map, even if the location is selected, before or after saving the record.
Your thoughts, input, suggestions, recommendations, are much appreciated!
------------------------------
Andrew
------------------------------