Posted by pb648174 on 10/01/75 11:42

I played with adding a Module table but then I lose ref integrity when
the module line items are deleted. So I would need to add a
ModuleLineItem table as well (??) and then I have ref integrity
problems with the other tables linking to it...

P.S. Identity columns are awesome.

• Next in forum: Re: Getting previous values of a field
• Prev in forum: Re: Compare given period in current year / previous year
• Thread view: Re: Finding the natural key

[Reply to this message]