Adding a field with a FG constraint

[Viktor]

I have one rather theoretical (at least in this moment) question. I already have a working SQL2000 database as a backend. The situation is the following. All of a sudden I should create new table with different PeopleAttributes which will be in a relation with the People table, and accordingly I should add another field in the table People. Is there a way to do this elegantly through VB2003 or I should do this directly through the SQL server (because some of the forms associated with the People table, eg. those that are used for filling the table, would not work (at least I think so) because there will be a null value in the FK field)?.

I hope this made sense

Thanks,
Viktor

 

[cjard]

the designer normally changes your:

SELECT * FROM People

to SELECT <list of all field names known at the time> FROM people


for a good reason.. But even then, if you select 100 columns but your datatable only can hold 50, the other 50 thigns you select arte discarded

The idea is that you can add columns without affecting the app.. The only time to affect the app comes when you want to use those columns in the app