This topic is locked

delete one record deletes all

2/19/2009 1:29:47 PM
ASPRunnerPro General questions
J
jmccullough author

New user here so not exactly sure how to ask this question. We have a vendor bid entry table linked to vendors table and also to an item entry table. When we list all records in the Vendor Bid List table, select for example Item # 1006 which has 5 associated entries but from different Vendors. (Item #'s can be multiple but Vendor #'s are different). If I check the select box for one of the 1006 items and the click on "delete selected", it deletes all of the 1006 entries not just the one selected. What am I doing wrong? Any help is appreciated.

J
Jane 2/20/2009

Hi,
please make sure you have set up correct primary key on the Choose pages tab. Primary key should be unique.

I suppose you need to select Item # and Vendor # as compound primary key.