Sorry, I am not sure how to model this. Are you able to show an example with a diagram, please?

Thanks a lot.

Hi ratbak,

Yes, we need to track if a plot is subdivided or merged. Can you explain how to do this?

Thanks

Ok here is what I am trying to achieve and I have come up with a design. If someone can cast their eyes on the design and let me know...

Please look at the post below:

• This reply was modified 1 year, 2 months ago by  rgarayia.
• This reply was modified 1 year, 2 months ago by  rgarayia.
• This reply was modified 1 year, 2 months ago by  rgarayia.

The link seems useful but if somebody can give a script that I can use that would be really helpful as I am newbie to SQL Server.