Hi Everyone, I have two tables, Client and Matters. Based on those two table I have two Forms Client and Matters. There is a button on client form when I clik this button it open up the matter form with ClientID. What I want to achieve is when it open matter form like it copies clientID at the same time it should automatically generate next matterID for the same client. I mean one client can have many matters if matter for the same client eist should generate the next matterID for the same client. If clientId is change should start the sequence from number one again. Please answer with example. thanks in advance.
Can someone check the attached db file and advise where changes are required to achieve the required result.
Can someone check the attached db file and advise where changes are required to achieve the required result.
