Linking records between multiple lists - Client and products for Finance company

[TrackFinancial]

Hi,



I am very new to Access so I'm not sure if what I am trying to do is either really simple or really complicated!

I am trying to put together a database that tracks individual clients and what products they selected for a finance company. I have setup the CLIENTS list but because each client will have different (and multiple) services I wanted to add the SERVICES list as a separate item and then link each product to the individuals that each record relates to. There may also be two clients on the one product so again it would be ideal if the product (i.e a Home Loan product) was setup in the SERVICES list, and then I could link One or Two clients to that individual mortgage record using their data which is stored in the CLIENTS list.

Thanks for any help!!

Ben.

[June7]

Sounds like Clients and Services have a many-to-many relationship. This requires a third 'junction' table for records that relate clients and services.

tblClientsServices
ClientID (foreign key)
ServiceID (foreign key)

[TrackFinancial]

Ok ill give it a go. Thanks for the info.