Help allocating Primary/Foreign Keys and Relationships

[rosscortb]

Hello,

Trying to get to grips with relational ship design. Please can you help me with tables design. I know one employee only lives at one address but if they move I want to record this. Also, one address may have one or more than one costs. I am struggling with the putting it so the address costs only go against the one address. Based on the attached can you indicate if I need to change primary keys etc. Thanks Ross

[CJ_London]

1. Change the name of your Address table ID field to AddressID (for clarity)
2. Add a new field called EmployeeID (type long) to address table and link your Employee table to this field instead
3. with the data you have, not sure why you need a separate table for costs - it could just be included in the address table. However if you want to record separate rents for different years, keeping it separate makes sense, but you need to add something else such as a 'rent from' date - and as with addresses, change ID to CostID and add an AddressID (type long) which links to the address table

[rosscortb]

Hi. Thanks for your help yesterday. Attached is where I am today

I have created some forms. I have a Personal Details(Main form) and link to the address (linked Form), when i click it opens up with the right addresses against the right employee so that's fine. On the address form there is button that takes you to the Address Costs form and it opens up against the correct costs against the correct address so that's fine but when I add a new cost should the address ID not automatically populate, in the attached case the number 4. Hope this makes sense cheers
Ross