Hi,
I am a very newbie... access 2007
I have a member database over a "club" with several members.
I got a memberstable
With names and addresses telephone ect. ect.
I have read that you should take thing out of the main table if not all have something to put into the fields. Like address3 and address4 - it should be in a new table.
NOW
In my db I have some activities "around" 8 fields that not all of the members are involved in.
Therefore will it be a db with a lot of empty spaces.
I need another table to fill this input in and after that make a form that contian both the members table and the activities tables for overview and for editing.
Anyone who can help me with this setup.
I got a few other tables there works fine but when I try to make this working I ran into different major problems.
Please help my through!
I am a very newbie... access 2007
I have a member database over a "club" with several members.
I got a memberstable
With names and addresses telephone ect. ect.
I have read that you should take thing out of the main table if not all have something to put into the fields. Like address3 and address4 - it should be in a new table.
NOW
In my db I have some activities "around" 8 fields that not all of the members are involved in.
Therefore will it be a db with a lot of empty spaces.
I need another table to fill this input in and after that make a form that contian both the members table and the activities tables for overview and for editing.
Anyone who can help me with this setup.
I got a few other tables there works fine but when I try to make this working I ran into different major problems.
Please help my through!
Last edited:
