Hi! I'm a foreigner working in japan and my job has recently put me in a position where I have to use Access for the first time. I've managed to create some tables and establish relationships between them, but I got stuck trying to create a form with subforms.
I have a table with PlaceNames and PlaceID's (primary key) to which I linked (one to many) many other tables containing various data for every place.
To make data entry easier, I would like to create a form where I have the PlaceName and PlaceID in a main form and a subform for every other table linked through that PlaceID. When I do this, however, only the subforms for which I've already inserted some data show with all the fields. Subforms that don't contain any data yet, show up without any fields, which makes data entry impossible...
It might be a silly question, but I would really appreciate it if someone could tell me how to solve this problem. Maybe it is not possible and I misunderstood the whole concept of forms?... Either way, it would help me a lot if you could let me know!