Thanks,
My original database in Approach is huge and handling statement of accounts, stock system, invoicing, bookings, sales etc. im not designing as I go, just trying to understand how Access works in comparison to Approach as there is no point in me building the rest of the system if I am unable to resolve the first issue I come across.
I will make the changes you have highlighted above.
In Approach, when you make a join for relationship purposes then those are automatically used for look-up/query purposes and I think this may be where I am becoming confused.
I can use those joins but I dont understand how that produces the result of auto-populating the form when I type in the door number and postcode.
In the UK we dont have zipcodes. The combined door number and postcode unique identify a particular house which is why the door number is separate from the rest of the address.
Also, even with your changes I am still unable to enter data in the form. I still get 'the recordset is not unpadatble' at the bottom. Any ideas why this is?
Thanks