AnsweredAssumed Answered

Looking up Problem

Question asked by ToddNolan on Feb 3, 2015
Latest reply on Feb 4, 2015 by ToddNolan


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.