Normal Topic Sub Form navigation issues (Read 983 times)
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Sub Form navigation issues
Jan 5th, 2004 at 1:01am
Print Post Print Post  
From Tutorial, Section 5, Sub Forms.

1.  Sub forms, need to press F10 to enter next line vs. Tab or Enter, treating like a new record.  "Ditto" feature seems inconsistent.  On new line, pressing F5 does not repeat entry of previous record field, but Shift F5 duplicates the previous record.

2.  If I go to add items to a Subform it allows me to do that.  It does not require a key to a parent item.  This allows creation of orphans.

3.  If I go to a Parent form, it allows me to delete the form, creating orphans records in the sub form.  Any way to create dependencies?

4.  Adding Tabs to Subform, automatically creates new fields on ParentForm, no warning.  May not be wanted.

5.  If multiple tabs on a form, pressing delete on one specific tab removes all tabs, not just the active one.  Undo cannot undo.  All work is lost.
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Sub Form navigation issues
Reply #1 - Jan 5th, 2004 at 1:46am
Print Post Print Post  
Quote:
2.  If I go to add items to a Subform it allows me to do that.  It does not require a key to a parent item.  This allows creation of orphans.

If you are using natural linking, you are not creating orphans.  No keys are needed. If you are using relational linking, you are responsible for your own bookkeeping. If you choose to match relational keys, fine.  If you want to enter relational records on a form that do not necessarily appear under that parent, you can do that too.

Quote:
3.  If I go to a Parent form, it allows me to delete the form, creating orphans records in the sub form.  Any way to create dependencies?

Same as above.

Quote:
4.  Adding Tabs to Subform, automatically creates new fields on ParentForm, no warning.  May not be wanted.

I'm not sure what you mean by this. I'll give it a try and see if I see fields being added somewhere.

Quote:
5.  If multiple tabs on a form, pressing delete on one specific tab removes all tabs, not just the active one.  Undo cannot undo.  All work is lost.

Right-click on the tab group to add/remove individual tab pages. If you accidentally delete the tab group, exit the form without saving your changes.  This will preserve your work since the last save. It is generally a good idea to save periodically as you work.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged