4 Replies Latest reply on Feb 4, 2015 5:24 AM by ToddNolan

    Looking up Problem



      Looking up Problem


      I have two tables. ClientTable and AgentTable. 

      ClientTable has fields: AgentID and AgentName  plus others...

      AgentTable has fields: AID (Auto-serial + 1 each commit), AName


      When a user selects an agent's name from a drop down datalist for field AgentName, I want to be able to pull the AID to match that AgentName field.

      IF that makes sense? Any ideas?

      I can't seem to find a way to bring the Agent's unqiue ID from the agentable along with his AgentName in a drop down box.


      Ultimately, I would like for users to be able to choose an agentname from a drop down box from a client table, but if the agent changes addresses, name tags, etc in the agenttable, it will still be connected (updated automatically for the clients that choose he/she as there agent) to that client. I didn't want to use the unqiue agent id because who would want to remember who agent 1, 2, 3 ... is.