Linking in forms

[vgatell]

Hi:

I run large database and need to modify. I use a large "Incident" table and
use several forms to enter data. My problem is that when I open a second form
(my table is too large for just one form) I need to be taken to the Record
that I was working on.

How can I automate this?

Vic

 

[tina]

if the table has too many fields to fit comfortably on a form to make for
easy data entry, then
1) suggest you add a tab control to the form, to provide additional screen
"real estate" so you can fit all the controls you need on a single form, and
2) suggest you review your table structure. any table with more than 25-30
fields is highly likely to *not* be normalized. for more information on data
normalization, see
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101.

hth

 

[vgatell]

Thank you Tina:

I have a few of those tricks up my sleeve, I was hoping that I could find a
simple solution to my dilema without code.

Vic

if the table has too many fields to fit comfortably on a form to make for
easy data entry, then
1) suggest you add a tab control to the form, to provide additional screen
"real estate" so you can fit all the controls you need on a single form, and
2) suggest you review your table structure. any table with more than 25-30
fields is highly likely to *not* be normalized. for more information on data
normalization, see
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101.

hth

Hi:

[quoted text clipped - 6 lines]

Vic

 

[tina]

well, adding a tab control to increase screen real estate doesn't require
any code at all, and is considerably simpler than linking multiple
additional forms. correcting normalization errors in the underlying table
structure also requires no code; though if you've gotten very far in
building the user interface, it may take considerable work to rewrite those
objects to fit the revised structure - but i think most experienced
developers would say it's well worth it in the long run.

hth

Thank you Tina:

I have a few of those tricks up my sleeve, I was hoping that I could find a
simple solution to my dilema without code.

Vic

if the table has too many fields to fit comfortably on a form to make for
easy data entry, then
1) suggest you add a tab control to the form, to provide additional screen
"real estate" so you can fit all the controls you need on a single form, and
2) suggest you review your table structure. any table with more than 25-30
fields is highly likely to *not* be normalized. for more information on data
normalization, see
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#Dat abaseDesign101.

hth

Hi:

[quoted text clipped - 6 lines]

Vic