If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
working with northwind template
I am trying to use the northwind template and need to know how to edit the
data that comes with the template to put in mine. I have been able to edit the logo and name on the forms but in, for example, the inventory list- I can't delete the products listed. |
#2
|
|||
|
|||
working with northwind template
There are some rules about deleting data.
When there is a relationship between 2 tables, any child records in the child table must be deleted before the parent records can be deleted. When you try to delete inventory transactions in northwind, you get a message telling that you can't delete because there are related records in the table called Purchase Order Details. That means, you need to delete the data in the Purchase Order Details table before you can delete the data in the Inventory Transactions table. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "silverton" wrote in message ... I am trying to use the northwind template and need to know how to edit the data that comes with the template to put in mine. I have been able to edit the logo and name on the forms but in, for example, the inventory list- I can't delete the products listed. |
#3
|
|||
|
|||
working with northwind template
Thanks for the reply. I am still having issues with deleting items in many of
the lists. Why isn't there a delete option for these tables? I was able to remove employees but that's it. I did delete purchase order records and still can't delete inventory transactions. "Jeanette Cunningham" wrote: There are some rules about deleting data. When there is a relationship between 2 tables, any child records in the child table must be deleted before the parent records can be deleted. When you try to delete inventory transactions in northwind, you get a message telling that you can't delete because there are related records in the table called Purchase Order Details. That means, you need to delete the data in the Purchase Order Details table before you can delete the data in the Inventory Transactions table. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "silverton" wrote in message ... I am trying to use the northwind template and need to know how to edit the data that comes with the template to put in mine. I have been able to edit the logo and name on the forms but in, for example, the inventory list- I can't delete the products listed. . |
#4
|
|||
|
|||
working with northwind template
"silverton" wrote: Thanks for the reply. I am still having issues with deleting items in many of the lists. Why isn't there a delete option for these tables? I was able to remove employees but that's it. I did delete purchase order records and still can't delete inventory transactions. "Jeanette Cunningham" wrote: There are some rules about deleting data. When there is a relationship between 2 tables, any child records in the child table must be deleted before the parent records can be deleted. When you try to delete inventory transactions in northwind, you get a message telling that you can't delete because there are related records in the table called Purchase Order Details. That means, you need to delete the data in the Purchase Order Details table before you can delete the data in the Inventory Transactions table. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "silverton" wrote in message ... I am trying to use the northwind template and need to know how to edit the data that comes with the template to put in mine. I have been able to edit the logo and name on the forms but in, for example, the inventory list- I can't delete the products listed. Silverton, Working from a "copy" of Northwind you could copy and paste the table “structure only“just rename the copy of the table with a _ after the name. Once you have done that to ALL the tables you then delete the all the tables without the underscore _ Access will ask if you want to break the relationships just answer yes. You now can just delete all the trailing _ after the table names. Next open the original Northwind and set the relationships on your copy exactly the way the original is. hth Richard |
#5
|
|||
|
|||
working with northwind template
When you are stopped from deleting data in a table, there is an error
message that tells you which table is causing the problem That way you know which table to delete from next. There are quite a few tables related to inventory transactions, you will need to delete data from quite a few of them before you can delete the data from the inventory transactions table. Because access always gives you a message with the name of the table withe related records, you always will know which table to delete from. Yes, I suppose it would be handy to have a button which clears out Northwind tables. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "silverton" wrote in message ... Thanks for the reply. I am still having issues with deleting items in many of the lists. Why isn't there a delete option for these tables? I was able to remove employees but that's it. I did delete purchase order records and still can't delete inventory transactions. "Jeanette Cunningham" wrote: There are some rules about deleting data. When there is a relationship between 2 tables, any child records in the child table must be deleted before the parent records can be deleted. When you try to delete inventory transactions in northwind, you get a message telling that you can't delete because there are related records in the table called Purchase Order Details. That means, you need to delete the data in the Purchase Order Details table before you can delete the data in the Inventory Transactions table. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "silverton" wrote in message ... I am trying to use the northwind template and need to know how to edit the data that comes with the template to put in mine. I have been able to edit the logo and name on the forms but in, for example, the inventory list- I can't delete the products listed. . |
Thread Tools | |
Display Modes | |
|
|