Been working on this for a few hours now, can't see the light.
Two tables, one with a list of British Postcodes, one with a list of companies.
Easy so far.
Companies can cover several postcodes.
and
Postcodes can have several Companies.
I need to relate them so when a postcode is chosen, all the companies that work in that postcode appear, and if a company is chosen, all the postcodes that company covers are listed.
Any help please.
Alan
Two tables, one with a list of British Postcodes, one with a list of companies.
Easy so far.
Companies can cover several postcodes.
and
Postcodes can have several Companies.
I need to relate them so when a postcode is chosen, all the companies that work in that postcode appear, and if a company is chosen, all the postcodes that company covers are listed.
Any help please.
Alan