Originally Posted by
Ajax
you need a separate table for each entity type - customers, contacts, memos, industry etc
Addresses - depends on the customer, if they can have multiple addresses then they need tier own table as well. Same for contact numbers etc if a contact can have multiple phone number types e.g. office, mobile then they can go in the contacts table, but if they have multiple office numbers, they go in a separate table.
each table should have a primary key and where a child table is linked to a parent (e.g. contact is a child of company) you also need a 'family' or 'foreign' key in the child table which maps to the parent primary key as a relationship
you should be asking this question once you have defined all your tables and relationships. but in principle you would have a main form (company) with a subform (contacts)
yes - to early to say how this is achieved (other than you will use a query and vba) but perfectly possible.
don't think of access as being a large excel, it is nothing like. Also remember that tables are for data storage, nothing else, do not get into the habit of looking at your tables as a 'finished' view. Use forms/reports via queries.
you may well find there is a contact management template available in Access which will perhaps give you some ideas as to how things might work, but I would avoid trying to modify them to meet your needs. You will end up spending more time trying to 'fix' it whilst not really understanding what you are doing or why. Better to build from scratch and use the templates to see the principles applied