Struggling with many-to-many input form

[ikselle]

At the entry of a parkingplace a guard has to keep trace of the users. He introduces a licenseplate and should get the name of the person bound to this plate. But it happens that a car is used by family or other employees. To keep trace of this the guard should be able to introduce the name of the unusual user.
Can anybody PLEASE help me with this inputFORM ? I'm struggling now with this problem for a while. Thanks in advance !!

 

[plog]

1 Table, 1 Form. When you want to create a form to directly interact with data (add/edit/delete) it should be based on just one table, not a query. When you have a many-many relationship this means creating a subform based on the junction table.

You should create 3 forms--1 for each table. When a car drives up the guard can type in the license plate and open the license plate form. At the bottom of that form will be a sub-form based on tblPersonLicenseJunction that shows all users associated with that license plate. If the current driver is not there, he would open the Person form, add the person and then return to the License form and add him to the subform for that license.

 

[ikselle]

thank you plog for giving me the idea. but i really need something concrete.

 

[plog]

My first paragraph was an explanation of the why, the second paragraph was a concrete how. What would make it more concrete?

 

[ikselle]

Sorry but for me concrete would be an example with the included database. Is it a big effort for you to use it in my database ? Anyway, thanks a lot. I really appreciate your help.

 

[plog]

Its not an effort I want to undertake. Honestly you can use the wizards to make the 3 forms I described, then this guide to link your subform to a main form:

https://support.office.com/en-us/ar...any-form-ddf3822f-8aba-49cb-831a-1e74d6f5f06b