linked form problems, How to delete

[chaft]

I have a child form that creates the details for my Conferences.

Which another form has two fields that are linked by dropdown boxes to two of the fields that are created from this child form.


conference info Master table
name of conference name of person
name of place address
name of conference
name of place

ok so the two field in both tables are linked via dropdown tables. The problem is that if I delete the data in the two fields from conference info then my information for those fields on the 'master table' gets deleted too.

What's a way to delete all the master table records that when the name of conference and name of place are deleted from the conference info form?

I suppose I need to find all records that match the records and delete all, but as I don't have any relationship set up between these two tables except the linked dropdowns how might i do this?

 

[Remou]

It seems that your database may not be set up properly. Have you read

http://www.r937.com/relational.html?

The normal way to set up such a system would be on the lines of:

tblConference
ConfID

tblLocation
LocID

tblPersons
PersonID

tblConfPersons
ConfID
PersonID

The above is very simplistic, the actual set-up would depend on the type and frequency of conferences and a number of other real-world attributes.

 

[chaft]

I rearranged my relationships while focusing on how many to many relationships were worked around (having 2 one to many relationships and a in-between table). Much happier now. Thanks