•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 373,936 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,013 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser:
Views: 1848 | Replies: 5 | Solved
•
•
Join Date: Apr 2007
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
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!
Thanks!
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!
Thanks!
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
- Defaulting values in MS Access subform (MS Access and FileMaker Pro)
- Passing variables into form fields (PHP)
- Editing/Creating PHP Fields - Novice! Help? (PHP)
- Populating a fields on a form base on a selected item from a droplist. (PHP)
- Loing authentication fields from 2 tables? (ASP)
- searching multiple fields (PHP)
- Add Fields to the Details View of Folders (Windows tips 'n' tweaks)
- Tab control on hidden input fields (HTML and CSS)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Access/Jet SQL: Date/time issues
- Next Thread: MS Access vs. MySQL



Threaded Mode