Re: Data changes but reverts. ... > trust my data to a wizard-built form.... > 3) What is the primary and foreign key in your relationship ... I did a TABLEUPDATE() and it's now working! ... The symbol field is the primary key in the Symbols table and it is ... (microsoft.public.fox.programmer.exchange)
Re: writing a Delete trigger on a table for cascading effect ... "But our developers out here do not beleive in primary key and foreign key...constraints so putting constraints on tables is ruled out" ... You get a trigger that fires on a delete only. ... (microsoft.public.sqlserver.programming)
RE: Creating an DB for an Office Rota/Skills ... Also how do i set up a foreign key?...primary key because atm i have to type them in eg. 1.2.3.4.5 for each persons ..."Duane Hookom" wrote: ... fields for skills and/or days then you are on your own. ... (microsoft.public.access.tablesdbdesign)
Re: Database Design Question ... > Using foreign keys to form a composite primary key of a child ... > LanguageId int identitynot null, ... If the foreign key does not lead the Primary Key, ... (microsoft.public.sqlserver.server)
