Forum Discussion
- MCFNeilQrew CaptainAny reason why "House Name" is not its own text field?
- jameskippQrew MemberI'm struggling with the same issue. For example, I want my reports to show "Airport" rather than an unrecognizable long street address which is unfamiliar to the database users. Is this possible?
- RyanHuffmanQrew CadetAgreed. We often use locations that you would be able to type in the name of the location (like "Hilton Gardens Inn, Anyplace, USA") and an application like Google Maps would at least list suggestions if the search criteria are not specific enough. With the "Location" field lookup feature being driven by Google maps, I'm surprised the lookup function is not more dynamic but it cannot find anything but addresses.
For now I've added an extra text field for users to manually enter any place names like this though so we can show the name when appropriate and the address when appropriate. - jameskippQrew MemberI ended up creating a separate Locations table with "Names" and "Addresses", which works well for repeated locations.
My details table has a related names field which will look up the address, resulting in functional name and address fields in my reports.
2 downsides: A) the initial use of an address still requires a google search (ie "Hilton Gardens Inn, Atlanta) to find the correct address. B) I haven't figured out how to use one-off addresses without adding them permanently (and dirtying) the locations list. I trust there's a solution for this latter issue.