Adding data to many to many tables

[fnem]

I am a novice so be gentle, I'm sure this is very simple when you know how.

I am making a database for my lawncare business. I have a table for customers Tbl_Cust with all the usual info, name, address etc and primary key CustID , I then have this linked to a table for treatment sites Tbl_TrtSite which contains TrtSiteID (primary key) TrtSiteType (type of site, from another table), TrtSiteArea (area of site) and TrtSiteDesc (description).

Tbl_Cust and Tbl_TrtSite are linked via a junction table, Tbl_CusttoTrtSite that has TrtSiteID and CustID as the primary keys.



I have a form, Frm_AddCust where I add a new customer, at the same time I want to add their treatment sites, could be more than one and will have a type, area and description for each, I imagine I do this through use of a subform but am a bit out of my depth knowing exactly how to go about it with the junction table etc.

Any and all help gratefully received. Thanks.

[pbaldy]

Try a subform bound to the junction table, with master/child links on the customer field.