Hello everyone
Let me first explain what I want to achieve? I have two different forms based on tables 'Client' and 'Matters'. Client table has the following fields:
1-ClientID (primary key)
2-FirstName etc...
Whereas the Matter table has the following fields:
1-MatterID
2-ClientID
3-Matter details etc...
MatterID and ClientID are combination of primary key. What I want to achieve is when I click the Matter button of Client form Client form should pass the clientid to matter form and generate unique Matterid based on Clientid and Matterid like (clientid=2000 and matter id 1,2,3 for each client. but each client matter should start from 1,2,3 and so on.
Your kind advice will be highly appreciated.
Let me first explain what I want to achieve? I have two different forms based on tables 'Client' and 'Matters'. Client table has the following fields:
1-ClientID (primary key)
2-FirstName etc...
Whereas the Matter table has the following fields:
1-MatterID
2-ClientID
3-Matter details etc...
MatterID and ClientID are combination of primary key. What I want to achieve is when I click the Matter button of Client form Client form should pass the clientid to matter form and generate unique Matterid based on Clientid and Matterid like (clientid=2000 and matter id 1,2,3 for each client. but each client matter should start from 1,2,3 and so on.
Your kind advice will be highly appreciated.