CAnnot get Many to many relationship to work | Access forum

Resolved · Medium Priority · Version 2016

Thu 30 Aug 2018, 00:49 Delegate stuart said...

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?

Thu 30 Aug 2018, 06:44 Trainer Jens said...

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

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Access tip:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips