I wish to have some advice about fixing problems with forms reading and writing junction table. I use a junction table to connect different tables as a central form for reading some fields and writing other fields belonging to different tables.
1. What decides whether you can write or just read in fields in a form.
2. How connect the ID-field numbers with corresponding namefields in the same table to let the ID-number accompany the names when you change names in a form? Can I do it when I use a wizard?
3. I have problems when I write for example name-information in fields for names. Then numbers of the ID-numbers are written in the field for names. How can I avoid that?
I attach the database. I would be very very glad if somebody could help me forward.
1. What decides whether you can write or just read in fields in a form.
2. How connect the ID-field numbers with corresponding namefields in the same table to let the ID-number accompany the names when you change names in a form? Can I do it when I use a wizard?
3. I have problems when I write for example name-information in fields for names. Then numbers of the ID-numbers are written in the field for names. How can I avoid that?
I attach the database. I would be very very glad if somebody could help me forward.