Synching a form with multiple subforms

[JustJen]

Hello,

I am a crime analyst working for a police department with no budget and am
attempting to design an intelligence data management system with Access 2000.
After reading that, if anyone is still interested in helping me, here is my
problem.

I have an EVENT form as the main entry form. On the EVENT form, I have two
command buttons that open PERSON and VEHICLE subforms separately (these are
many-to-many relationship tables to the EVENT table). I can synchronize the
PEOPLE subform, but can't get the VEHICLE subform to synch. Do I have to have
a separate FilterChildForm code procedure in the main form that defines
another procedure (possibly FilterChildForm2 ()???) for the VEHICLE subform?
Or does one do it all? The link fields are EVENTID via a linking table for
both.

I am not a programmer and am learning Access via a book, the inernal help,
and searching the web as I go. I'm stumped on this one. Any one want to take
a shot?

 

[tina]

you can't express a many-to-many relationship directly, in Access, so it's
not clear what your tables/relationships are. until we understand that, it's
difficult to help you solve your forms problem. please post a description of
your tables/relationships. example:

tblProducts
ProductID (primary key)
ProductName

tblOrders
OrderID (primary key)
OrderDate

tblProductOrders (often named tblOrderDetails)
ProdOrdID (primary key)
ProductID (foreign key from tblProducts)
OrderID (foreign key from tblOrders)
Quantity

relationships are
tblProducts.ProductID 1:n tblProductOrders.ProductID
tblOrders.OrderID 1:n tblProductOrders.OrderID

the above is classic example of a many-to-many relationship (between
Products and Orders), expressed as two one-to-many relationships: one
Product to many ProductOrders, and one Order to many ProductOrders.

hth