开发者

Creating Access 2007 Subforms on a Tab Control

开发者 https://www.devze.com 2023-02-24 09:10 出处:网络
The main entity in开发者_如何学Go my database has about a hundred fields.I organized the fields between many tables and added a 1-to-1 relationship between the tables.

The main entity in开发者_如何学Go my database has about a hundred fields. I organized the fields between many tables and added a 1-to-1 relationship between the tables.

For data entry (and later data editing), I envision a "wizard" with a form for each table and a "Next" button to advance to the next screen/table. The primary key would be entered on the first screen and subsequently passed to all remaining screens.

I have heard a tab control with subforms might be the way to go.

What steps should I perform to create this wizard?

Note: Use the following schema as a simplified example of my database. Sample Schema (can't upload images from work)


You can use a hidden TextField in the parent form which contains your primary ID. For every of your subforms you just set in the properties that the subform is linked to the content of this textfield. This way you can get all your subforms synchronized.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号