I work for a company that delivers services to private and domestic clients
I currently have two bases set up.
One which lists ‘People’ Base 1
One which lists ‘Companies’ Base 2
In both bases are examples of clients. i.e. we may work for Acme Ltd (Company) or Mrs Smith (Person).
However the companies base is not exclusively clients (it also includes supplier etc) and the contacts base isn’t exclusively clients (also includes people who work for companies)
Is there a way I can pull companies labelled as clients and individuals labelled as clients into a new base called clients?