I need some tips and trix on how to start working with access in a better way.
I have just started to think about a new project.
This time i want to avoid large tables and split them up in smaller more managable tables.
But now when i have my first set of tables to try this out....
Person_Table
Phone_Table
Address_Table
When i start to build a form to act as a profile, display the person and all its contact information.
Only way i can come to think of how to do this is a form with different subforms.
But i really struggle to work with subforms... they look so awful in terms of leaving dead space after last record and not removing scrollbars even tho there are plenty of space left under the last record.
So now i want to know if i am missing something.
Is there another way of displaying data from several tables that have a relationship, in a form?
For example a person with 4 phonenumbers and another with just 1.... make it look somewhat decent....