Linking records in same table

[mattkorguk]

Hi,
I have been thinking of allowing our users to be able to link records together within our database.
We have a CRM system that lists customers and their details of mortgages and other insurance related products which they have. Some entries maybe linked in some way, possibly other family members etc.

My question is, is it possible to perform this kind of action? So they can then see relationships between either related records (ID ref etc).

I'm sure I've seen this in SQL based applications, but haven't come across it within Access.

Thanks
Matt

 

[RuralGuy]

Maybe this link will be helpful.

 

[mattkorguk]

Thanks RG, some other useful bits and bobs on there.