I have been creating a simple contacts/company database.for a design company doing logo's company branding marketing etc..

I have asked if i can perform an extra facility which has got me stumped.

Quick explanation

5 layouts

company details,contact,type of work/business,stratagy,reports

this is all fine if you have one contact at a company and one type of business relationship.

I have been asked to allow for multiple contacts at a company that may be large and may be doing different business

therefore the 2nd and 3rd layouts/feilds contained must be able to be repeated upto 5 times.

i need something on the main layout to give some indication of whether there is more than one brief happening and link to the contacts and type of business layouts

I'm even confused when explaining this

please help

hope you get the idea.

You need to have one file for companies, and another for the contacts. Company and contact files would be related by a company ID field. Then you can have an unlimited number of contacts at any given company.

Just in case you were thinking of using repeating fields, DON'T. They don't provide the flexibility to do what you will eventually need to do as the database develops.