Creating Access 2007 Subforms on a Tab Control -
the main entity in database has hundred fields. organized fields between many tables , added 1-to-1 relationship between tables.
for data entry (and later data editing), envision "wizard" form each table , "next" button advance next screen/table. primary key entered on first screen , subsequently passed remaining screens.
i have heard tab control subforms might way go.
what steps should perform create wizard?
note: use following schema simplified example of database. sample schema (can't upload images work)
you can use hidden textfield in parent form contains primary id. every of subforms set in properties subform linked content of textfield. way can subforms synchronized.
Comments
Post a Comment