Search List 20 normalize help - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Search List 20 normalize help

Sean Sweeney

4 years ago

I was wondering how would I reference normalized data in the SQL-powered search field. I was trying to move away from "company" and replace it with "EntityID" - I managed to use Dlookup for the search display, however, the SQL doesn't seem to want to play nice

trying to replace "techsearchlistcompany" with "entityID" from my "LicensedEntitiesT" Table so it will work well in my "TechnicianListF" searchform.

	Sean Sweeney OP @Reply 4 years ago
Also my recordsource would have been "SELECT * FROM LicensedRepresenativesT ORDER BY Company;"

	Sean Sweeney OP @Reply 4 years ago
Perhaps disregard - I've made three of these forms, and I noticed my last one utilized the Dloopup from the start to address EntityID, so I think it would be best just to delete the form and start from the ground up.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View