Hello,
Sorry but I'm not very experienced when it comes to things like this. I have a table called Measure Table. This table has fields called "ID", "Proxy" and "ProxyID". I created a form based on this table. ID is pre populated from the table. Proxy is a drop down menu with the options "For" or "From". And ProxyID contains a drop down with the same numbers as ID. Ideally, I would like a user to go to the form and go to a specific record say for ID:I800 and select "For" from the Proxy drop down and then select ProxyID (lets say L800). For the record for L800, I want it to automatically change the proxy to "From" and the ProxyID to I800. Is this possible in Access? Thanks so much for any help provided.