i have a parent table and a few children table where I want every entry in the parent to have to have an entry in one of the child tables. Is there anyway to force this? The only way I know of is to create a query that finds any that are missing and from the child tables and add them, but if it could somehow 'automatically' do that when a new entry in the parent is added that would be best.
1-to-1 relationship
- Thread starter slide
- Start date
Table - Relation ship
hi,
even i have the problem some what like this..
I have a Resouce Database (Parent table) followed by 6 tables (like designation, experience level, accountability status etc) where i have to create a entity diagram to demonstrate relation between the tables, the idea is that once the parent table is updated witht he new records it should 'automatically' record in all the other tables.
Kindly help me whether we can do this? if s please do let me know the procedure
hi,
even i have the problem some what like this..
I have a Resouce Database (Parent table) followed by 6 tables (like designation, experience level, accountability status etc) where i have to create a entity diagram to demonstrate relation between the tables, the idea is that once the parent table is updated witht he new records it should 'automatically' record in all the other tables.
Kindly help me whether we can do this? if s please do let me know the procedure
