Basically, I only gave you a partial story.. The rest of it is that the join
tables are used in other relationships and the where conditions and join
conditions are getting sloppy. In addition, a lot of the front end deals
with dynamic forms and passing around a handful of IDs is getting
cumbersome.
Does that tip the scale either way?
Mike
> So, C is an identity or autonumber field?
>
> I have seen/done this, but not for the reasons you state --
> could you expand on how using C would ease writing of the where clause
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- OT: SQL Server Table Design Question Tangorre, Michael
- Re: OT: SQL Server Table Design Question Dick Applebaum
- RE: OT: SQL Server Table Design Question Tony Weeg
- Re: OT: SQL Server Table Design Question Tangorre, Michael
- Re: OT: SQL Server Table Design Question Dick Applebaum
- Re: OT: SQL Server Table Design Question Nick de Voil
- RE: OT: SQL Server Table Design Questio... Tom Kitta
- Re: OT: SQL Server Table Design Questio... Dick Applebaum
- RE: OT: SQL Server Table Design Question Tangorre, Michael
- Re: OT: SQL Server Table Design Question Dick Applebaum