AboutRichard Rost Expertise I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site.
Education/Credentials I am a self-taught Access expert. I have been building databases for clients since the early 90s. You can see a sample of my Access Tutorials on my web site at 599CD.com
First of all, I am a complete newbie with using Access, and i do not know anything about programming. I am using Access by creating tabels and forms with wizards. When googeling for help i find a lot of places with source codes etc, but i have no idea how that works..
Having mentioned this, here is my question. I am setting up a database with many related tabels. (see attached image)
I want other people to be able to easily enter data by using a form, so i am trying to create one form, with several nested subforms.
In each next tabel, i have some information from the previous tabel (a record ID). It starts with articles, one article, can have several sites, and one site several treatments, etc (see the relationship diagram).
In the form view, i can add another site record in the subform, wich is supposed to be still the same article record (articleId). This works more or less, but it seems almost randomly that sometimes the articleId is not copied into the sites tabel. See the image again; in the second row in the sites tabel, the articleId colums is empty. It should be articleId 31. Furher on articleId 32 is there twice, so that seems to be correct, but then again, articleId 33 is missing..
I have no clue why this is happening, have you got any idea? Thank you in advance!
Marianne
Answer Funny, I didn't know Europe was a country. :)
It sounds to me like you know what you're doing. If you're using the Subform Wizard and you have your relationships set up properly between your tables, then you should be just fine.
I don't know what the problem is with your forms not saving data to the tables. Without a copy of your database, I really couldn't troubleshoot this.
Here's a tutorial I recorded on subforms. Watch it and see if it helps.
See this tutorial on how to set up a Form with a SubForm to show related records:
P.P.S. I volunteer my time at AllExperts to help people, and I get a LOT of questions, so I can't take an hour to answer each question. If you need more DETAILED HELP, come to my TechHelp web site at http://www.599cd.com/TechHelp/AllExperts and I'll take as much time as you need to answer your question.
