Ask Your Question

Base form containing 100s of fields

asked 2019-10-10 16:45:35 +0200

biarced gravatar image

updated 2019-10-10 16:46:24 +0200

Hello: Newbie here. I have a database with 100s of fields. I need to make a user friendly form to input into the table. I do not want the user to get bogged down scrolling up and down a huge long form.

Is there a way to break up the form into tabs and sub-tabs to the user can enter the field values in a easier and ergonomic way?

Any help will be appreciated. Thank you.

edit retag flag offensive close merge delete



Many 'Databases' have 100's of fields. However it sounds as if you have this many in a single table. If that is correct, you may have a design problem and need to reconsider. Further explanation will help.

There are no built in Tabs in Base. You can simulate certain situations with macro coding.

Ratslinger gravatar imageRatslinger ( 2019-10-10 18:18:56 +0200 )edit


If you are going to cross post, please mention this via links in each post to eliminate double efforts. Also posted here -> Buttons to open forms of same records

It is also curious as to why you never responded to the comment.

Ratslinger gravatar imageRatslinger ( 2019-10-14 00:30:00 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2019-10-14 00:45:04 +0200

Ratslinger gravatar image


Based on additional but still somewhat limited information in the linked post, you have information in the record which should be split out into a separate table. That separate table would be one record per form and linked back to a specific record. You can have as many or as little # of forms as needed. This is part of 'normalization'. See-> What is Normalization? as just one of many posts explaining this.

edit flag offensive delete link more

answered 2019-10-12 04:25:50 +0200

LSemmens gravatar image

I would Bow to Ratslinger's expertise here, but my thinking would be create a master form with the critical data on it and then open other forms from there with related data. I hope you understand what I mean by Normalisation and Relations (i.e. loosely - grouping like data in one place so that changes are reflected throughout the entire database)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-10-10 16:45:35 +0200

Seen: 38 times

Last updated: 5 hours ago