C
Charles D Clayton Jr
A2K
I have two tables that have a 1 to many relationship - tblDrawings
(the one) & tblRevisions (the many). I can create a form to input
drawings into the table easily enough. However, I am having problems
with the Revisions. The primary key of tblDrawings ("ID_Isos"
autonumber) is the foreign key for tblRevisions. As I see it I need
to input the drawing name ("Iso") and sheet ("sht") and determine if
it is a new drawing or old drawing (It is important to note that we
can have the same "Iso" name but different sheet numbers). If it is
the old drawing name (which means it is a revision), then I need to
associate "ID_Isos" (Foreign Key)with the Primary Key of tblRevisions
("ID_Revs" autonumber).
Using ADO how do I do this?
Thanks,
Charles D Clayton Jr
I have two tables that have a 1 to many relationship - tblDrawings
(the one) & tblRevisions (the many). I can create a form to input
drawings into the table easily enough. However, I am having problems
with the Revisions. The primary key of tblDrawings ("ID_Isos"
autonumber) is the foreign key for tblRevisions. As I see it I need
to input the drawing name ("Iso") and sheet ("sht") and determine if
it is a new drawing or old drawing (It is important to note that we
can have the same "Iso" name but different sheet numbers). If it is
the old drawing name (which means it is a revision), then I need to
associate "ID_Isos" (Foreign Key)with the Primary Key of tblRevisions
("ID_Revs" autonumber).
Using ADO how do I do this?
Thanks,
Charles D Clayton Jr