I have one table (Table A listing members) with some fields being fed by other tables (call them B, C, D e.g. landlines) on a one-to-many relationship. I don't have data for all the entries in Table A that are fed from Tables B etc. (E.g. not all members have provided their landlines, but two members might have the same landline if they live together).
I am entering data for a new member in a form, but when I enter a new landline (on the same form), this then feeds through to all other members who haven't provided a phone number.
How do I stop this? (Sorry this is probably simple, but I haven't used Access for about 8 years)
Thanks