Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Going mad

0 views
Skip to first unread message

Ken

unread,
Mar 29, 1999, 3:00:00 AM3/29/99
to
I have one table "People" with three fields LastName, FirstName,
Telephone#, and I have a second table "PeopleInfo" with Lastname,
FirstName, Address, City, State, Zip, WorkPhone, etc. How come if I
linkthe two files on LastName and FirstName and make a form using all
the fields I cannot update the PeopleInfo fields. I have unchecked
the read only option on the table. It's really pissing me off!!

This is PDOXWIN 4.5 under Win98, by the way.

Ken

Ernie DeVries

unread,
Mar 29, 1999, 3:00:00 AM3/29/99
to
This is because you have a one-to-one relationship between the two
tables. In this situation Paradox designates the "child" (ie PeopleInfo)
as readonly. To fix it, go into the Form's data model & right-click the
PeopleInfo table, then deselect ReadOnly.

Ken

unread,
Mar 30, 1999, 3:00:00 AM3/30/99
to
Ernie DeVries <e...@jan.ucc.nau.edu> wrote:
As I said in my original post, I did uncheck read-only.

Ken

Richard Carter

unread,
Mar 31, 1999, 3:00:00 AM3/31/99
to
Ken (cant...@thespam.com) wrote:
: I have one table "People" with three fields LastName, FirstName,
: Telephone#, and I have a second table "PeopleInfo" with Lastname,
: FirstName, Address, City, State, Zip, WorkPhone, etc. How come if I
: linkthe two files on LastName and FirstName and make a form using all
: the fields I cannot update the PeopleInfo fields. I have unchecked
: the read only option on the table. It's really pissing me off!!

: This is PDOXWIN 4.5 under Win98, by the way.

You will not be able to change the values in fields you are
linking on in the detail table, because then, how would the
link be maintained. Read up on "Referential Integrity" with
the "Cascade" option, and make your changes in the master table.
--
============================================================
Rick Carter cart...@email.uc.edu rca...@tso.cin.ix.net
============================================================

Ken

unread,
Mar 31, 1999, 3:00:00 AM3/31/99
to
cart...@news.ececs.uc.edu (Richard Carter) wrote:

>Ken (cant...@thespam.com) wrote:
>: I have one table "People" with three fields LastName, FirstName,
>: Telephone#, and I have a second table "PeopleInfo" with Lastname,
>: FirstName, Address, City, State, Zip, WorkPhone, etc. How come if I
>: linkthe two files on LastName and FirstName and make a form using all
>: the fields I cannot update the PeopleInfo fields. I have unchecked
>: the read only option on the table. It's really pissing me off!!
>
>: This is PDOXWIN 4.5 under Win98, by the way.
>
>You will not be able to change the values in fields you are
>linking on in the detail table, because then, how would the
>link be maintained. Read up on "Referential Integrity" with
>the "Cascade" option, and make your changes in the master table.
>--

No, it's not the linked fields. Its the other fields that will not
accept updating. I think it's broke.

0 new messages