Create Input Form for Database with 88 tables (same structure)

[Alortiz]

CRUD, web database.



Why are you including all the tables in the form RecordSource? Normally a form can enter/edit data for only one table. Use form/subform arrangement. Main form should have only the parent table, not the 'child' tables. Child tables should be in subforms. Each subform on a page of tab control. A subform container control SourceObject can be table, query, form, report. 88 subforms would be a lot.

A Navigation form/control instead of tab control might be better suited (and I don't even like navigation form). If you intend to publish this db to web, might have to use navigation form anyway. I don't know if there is a limit on how many subforms can be associated with a Navigation form.

In my db I mentioned earlier, some samples have dozens of tests that can be associated. During sample login, tests are selected and records are immediately created in test tables. When testing is completed another form is opened for test data entry. Because these records are all 1-to-1 relationship, one query that joins all the relevant test tables can be the RecordSource of form. I have about 200 tests but the tests available for each sample depends on the type of sample. In most cases, a single form serves. A couple of cases results in too many tables for the query so I have to use subform.

The only reason why I'm including all the tables in the form is because the data collection inspectors need to see which record they are updating or creating. I understand why I would have to create subforms and will be using a nav form because it will be publish to the web. In order to minimize data entry errors the header info should only be entered when the new record is created, each section would then be related to the header record. In reality I only need 6 or 7 subforms but some may have too many fields. I'll give that a try and see how it works...

Thank you for your help!
p.s. I'm curious about the test db that you created, any chance you can share it (of course after sanitation)? Just like to see how similar that would be to the one I'm trying to develop.

[June7]

An old version can be downloaded from https://app.box.com/shared/r8nea07sng