Solution needed... please help

[willl]

Hi,

I have 2 mysql tables in my database.

One table I have insurance types (ie Pet insurance, Motor Insurance etc)

And in the other table I have Insurance Company profiles.

Now an insurance company may be able to provide more than one type of insurance so I want to be able to reference more than one insurance type to a companies profiles.

Can anyone think of a method to do this?? I'm thinking along the lines of adding each insurance type's id to that company's profile but thats where i'm stuck.

Many thanks

Will

[devinemke]

a standard many-to-many data relationship:

3 tables:
- insurance types
- insurance companies
- a third table that links them togther using the primary keys from both of the other two tables

[willl]

Understood,

Thanks for that. A bit rusty.

Will