Re: Changing table structure and losing a forms field position and reference
- From: "Dan" <megaflex@xxxxxxxxxxxxx>
- Date: Thu, 3 May 2007 16:26:13 -0400
Liz,
This is great! I took your advice did a table repair and all of the field
references came back to the correct reference location on my form. It also
worked if I just did a table restructure. It is important that I keep the
field names in the table structure in order.
Thanks again.
Dan
"Liz McGuire" <liz@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:463a3eca$1@xxxxxxxxxxxxxxxxxxxxxxxxxxx
If you add fields in places other than the end of the table, you could be
creating problems. At the very least, after this, you should run table
repair (not check, repair).
If you open the form in design mode and then restructure your table, it
may prevent the problem.
Better to just put new fields at the end - it's not like the position
matters - you can even save tableview properties with fields in the
position you prefer if you're using tableviews.
Liz
Dan wrote:
I have built an application that requires me to modify one or two table
structures once or twice a year. These tables are attached to a form. In
all cases, I am adding to the table structure with additional alpha field
types. My problems is that when the original form is opened, the fields
have shifted is some cases. Example: field027 configured on the orginal
form will now change to a random field say field30a. So when I look at
the original form several of the fields have changed locations. Is there
a way to lock these field positions on a form so they are always
referencing to the original field name? I hope this makes sense!
Thanks
Dan
.
- Follow-Ups:
- References:
- Prev by Date: Re: Changing table structure and losing a forms field position and reference
- Next by Date: Re: Changing table structure and losing a forms field position and reference
- Previous by thread: Re: Changing table structure and losing a forms field position and reference
- Next by thread: Re: Changing table structure and losing a forms field position and reference
- Index(es):
Relevant Pages
|
