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.