Search results

Thanks, I will try that.

I create a delete button on my form but sometimes it doesn't work (the record has not been deleted after I clicked it). Does any one know why ? thanks~!

Is it possible that a composite primary from table A to be a foreign key in table B? I have two tables: A and B. The A has some personal details such as first name, surname, phone number, etc. Since no personal ID is given in my project, I am thinking to use first name + surname as the primary...

Yes, you are right, I forgot to specify the "Cascade Delete option". It works fine now, thanks a lot! :)

Thanks for your reply!! But I did construct the relationship among these tables, and it didn't work. :confused:

I have a problem about deleting record from a form, it will be grateful if anyone can help me with this. Here are my tables: Par_tor: some personal details such as ID, name, phone NO., etc Par_tion: the record of who has participated which activities. Activity: name of the activity. My problem...