Add, Delete, Move ... in in a related table 
Author Message
 Add, Delete, Move ... in in a related table

How can i navigate (move, add, delete ...) in a database-table (for example
"orders") which has a relation to a higher table (for example "customer"). I
have defined the relations in the dataenvironment.

Thanks for all good ideas

Heinz



Sun, 05 Jan 2003 03:00:00 GMT  
 Add, Delete, Move ... in in a related table

Heinz,

You don't mention what database you're using. If you're using Access you're
in luck, because Access/Jet supports cascading deletes and updates which
means that if you delete/update a record the parent table, the related
records in child tables will also be deleted/updated.

--
Regards

Carsten Thomsen
MVP VB
MCSE/MCSD/VB Programmer & Analyst

PLEASE post ALL replies to the newsgroup(s) so we can all benefit from the
discussion!


Quote:
> How can i navigate (move, add, delete ...) in a database-table (for
example
> "orders") which has a relation to a higher table (for example "customer").
I
> have defined the relations in the dataenvironment.

> Thanks for all good ideas

> Heinz



Sun, 05 Jan 2003 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. HELP!!!!!Delete non-related records from another table

2. Cannot add record to Visual Foxpro table after deleting all records in table

3. Need Help in Adding records in the related tables

4. Adding new rows to related tables on a dataset

5. Appending related records to two related tables

6. Help deleting/adding columns to MDB tables

7. deleting records in a table and then adding new records

8. Add/Delete from Multiple Tables

9. Help deleting/adding columns to MDB tables

10. HOW i can create a form to make add,edit,delete,etc fro any table

11. HOWTO: Add/Delete Table from database

12. How to change add and delete String Table in Res

 

 
Powered by phpBB® Forum Software