R
Rodtnick
I imported a FoxPro 2 database into Access 2000 and have run into an
unexpected problem. I have two forms that are linked with each other, a
SERIES form and a PROGRAMS form. There are numerous PROGRAMS that
relate to a SERIES and the link is SERIES.SERIESID and PROGRAMS.P_IDNUM.
The problem is that when I imported the two databases, Access gave both
tables a new field called ID (SERIES.ID and PROGRAM.ID) and it is an
AutoNumber and the SERIES.ID no longer syncs with the PROGRAMS.P_IDNUM
so that when I try to add new records I have no proper relationships
between the two tables.
Is there a way to add another field to PROGRAMS and have it correspond
with the new SERIES.ID and then deleting PROGRAMS.P_IDNUM? I don't want
to have to do it by hand.
Thanx.
Bruce
unexpected problem. I have two forms that are linked with each other, a
SERIES form and a PROGRAMS form. There are numerous PROGRAMS that
relate to a SERIES and the link is SERIES.SERIESID and PROGRAMS.P_IDNUM.
The problem is that when I imported the two databases, Access gave both
tables a new field called ID (SERIES.ID and PROGRAM.ID) and it is an
AutoNumber and the SERIES.ID no longer syncs with the PROGRAMS.P_IDNUM
so that when I try to add new records I have no proper relationships
between the two tables.
Is there a way to add another field to PROGRAMS and have it correspond
with the new SERIES.ID and then deleting PROGRAMS.P_IDNUM? I don't want
to have to do it by hand.
Thanx.
Bruce