cannot get many many

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » CAnnot get Many to many relationship to work | Access forum

CAnnot get Many to many relationship to work | Access forum

resolvedResolved · Medium Priority · Version 2016

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


 

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


Server loaded in 0.07 secs.