stuart has attended:
Access VBA course
CAnnot get Many to many relationship to work
so i have set up a many to many relationship and a form bound to a query to capture the data
in the form, there is a sub form,
the form is to capture cleans on a vehicle, the sub form is what vehicles are being cleaned
when I save it, the junction table updates fine, but the deepclean table where the deepclean_ID primary key is, doesnt.
is there any way i can upload a test database to show you what is happening?
RE: CAnnot get Many to many relationship to work
Good morning Stuart,
Yes you can send it to:
info@microsofttraining.net
Unfortunately I am going on holiday next week. Unless I receive the example today (not to late) you may need to wait for an answer.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector