Help relating tables in a form

[alexmb1]

I am currently working a a project for a housing board and I have two tables, 'employees' and 'residences'. i have a form off of the 'employees' table that is where the housing board will work off of. it contains information like 'employee', 'permanent_address', 'zone', etc. I wanted to add a link to google maps for all the addresses in the housing pool. In the residence table i created a column called 'google_maps' where i store all the links to each residence. Since employees rotate housing i needed this to be here so when a new employee takes over anothers house, the links will not have to be updated but will instead always stay with the address.

I tried to simply just copy and past the new column ('google_maps') into the employees table so it would show up in the form. however, the address will not match up to the employees. it simply copies them ordinally. i have tried changing relationships and creating new tables that link the information but i am coming up empty handed.

in sum, i need to find out how to link the 'google_maps' from the residence table to the 'permanent_address' of the employee table.

let me know if there are any ideas or if i need to be more clear in my question.

thanks
alex

 

[alexmb1]

update:

I have my form set up so i can add links into the 'residence' table and have them match up with the correct employee in the 'employee' table. the problem now is that the recordset is not updatable. I have a section in the form where employees are proposed a housing assisnment and then when a button is clicked the proposed becomes the 'permanent' address. but now it is not letting me update. how can i correct this error?