Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

The form deletes but one table's record doesn't

Status
Not open for further replies.
jujutsu101

jujutsu101

Technical User
May 20, 2001
5
0
0
US
I have a query made up of a Billing Table and Site Table. (It is a carpet cleaning database.) I have a Customer Form based on the above query. I added a Delete button to delete the current record. It works on the Form. However when I check the Billing Table, the info is still there! I have a linked Form (Service) to the Customer Form. They are linked by SiteID. The Site table record does deletes as well as the Service linked record. But not the Billing Table. DO I NEED TO LINK THE SERVICE TABLE WITH BILLING ID AS WELL AS SITE ID? If not, then please help me. Thanks for your assistance.
Fred (jujutsu101@hotmail.com)
 
Status
Not open for further replies.

Similar threads

TinaS
  • Locked
  • Question
Quick one I think - question about Properties window in Form Design view
Replies
1
Views
63
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
124
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Forcing Form Updates
Replies
2
Views
85
TrekBiker
TrekBiker
renigar
  • Locked
  • Question
Trying to add hyperlinks to pdfs through form entry
Replies
0
Views
78
renigar
renigar
TomSalvato
  • Locked
  • Question
Getting the Monday date from a week number 1
Replies
2
Views
124
TomSalvato
TomSalvato

Part and Inventory Search

Sponsor

Back
Top