P
pietlinden
I'm working on an application where I don't have great control over
what people enter into my database - or whether they must fill in all
fields. If I were dealing with a form based directly or indirectly on
a "parent-most" table (well, not a child of another table), it would
be no problem. But...
I have an "enrollment" kind of problem.
Student---(1,M)---Enrollment---(M,1)----Course
is the generic problem.
My form is based on the "Enrollment" table. and then that table has
child tables.
I can check for the existence of records in Student and Course just
fine and create enrollment records using .Execute if no arguments are
left blank. I was thinking I needed that because I wanted to know if
the insert succeeded by getting the .RecordsAffected property of the
Execute (?) command.
I found Allen Browne's discussion from a while back here...
http://groups.google.com/group/micr...&lnk=gst&q=Execute+++.AddNew#921fec64f230707e
I can get the ID of the record by using
With rs
..AddNew
....
..Update
..Bookmark= .LastModified
....
End With
i'm not really interested in speed that much (because I'd enter a
single record at a time), but more in flexibility, because some fields
will not receive values, and there's not really any way I would know
which at design time.
Any ideas on which way is better in that case?
Thanks!
Pieter
what people enter into my database - or whether they must fill in all
fields. If I were dealing with a form based directly or indirectly on
a "parent-most" table (well, not a child of another table), it would
be no problem. But...
I have an "enrollment" kind of problem.
Student---(1,M)---Enrollment---(M,1)----Course
is the generic problem.
My form is based on the "Enrollment" table. and then that table has
child tables.
I can check for the existence of records in Student and Course just
fine and create enrollment records using .Execute if no arguments are
left blank. I was thinking I needed that because I wanted to know if
the insert succeeded by getting the .RecordsAffected property of the
Execute (?) command.
I found Allen Browne's discussion from a while back here...
http://groups.google.com/group/micr...&lnk=gst&q=Execute+++.AddNew#921fec64f230707e
I can get the ID of the record by using
With rs
..AddNew
....
..Update
..Bookmark= .LastModified
....
End With
i'm not really interested in speed that much (because I'd enter a
single record at a time), but more in flexibility, because some fields
will not receive values, and there's not really any way I would know
which at design time.
Any ideas on which way is better in that case?
Thanks!
Pieter