How to incoporate a big table in a form

[Ocean18]

I have a table that has more than 100 fields. Is there a way that I can incoporate all the fields in a form without denomalizing. Please advise. Thanks!

 

[BobStubbs]

Have a look at the Tab Control. This lets you arrange the fields in a form into a set of tabbed 'record cards' on the screen. It is then easy to group fields onto tabs, and give the tabs meaningful names.

As an example, think of an Employees table, with fields containing name and address, personal details, salary etc.

Place the EmployeeName and PayrollNumber fields on the main part of the form - these will always be visible.

Now create a Tab control, with tabs named [Personal] and [Employment].

Click the [Personal] tab. Use the Field List to put Home Address, Home Telephone, Date of Birth etc fields onto the [Personal] tab.

Click the [Employment] tab. Put Job Title, Department fields etc on the [Employment] tab.

Now, when you click between the tabs, you will only see the fields relating to that tab (but Name and Payroll Number will always be visible)

You can extend this to display a sub-form on a tab. For example, if you have a linked SalaryHistory table, you can create a [Salary] tab, then use the sub-form wizard to display this table on the [Salary] tab.

I hope this helps.

Bob Stubbs