Good Design?

Wow! I thought I was going to have to do some code in frmCallDetail like:

Private Sub Form_BeforeInsert(Cancel As Integer)
On Error GoTo Err_Form_BeforeInsert

Me.CallID.Value = Forms.frmCall.txtCallID

Exit_Form_BeforeInsert:
Exit Sub

Err_Form_BeforeInsert:
MsgBox Err.Description
Resume Exit_Form_BeforeInsert
End Sub

I'm glad you guys set me straight!

Clif McIrvin wrote:
In addition to what John said about Master / Child Link fields when you
have the one to many relationship between the two tables (these are
related tables, right?) set to enforce referential integrity the linking
is automatic.

--
Clif

I am fighting against the clock to figure out the record creation
concept for
[quoted text clipped - 11 lines]
Master
Link Field fills in automatically into the child link field.


--
---
TraciAnn

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200904/1

Yeah -- from personal experience it's really easy to think that I need
to do something that Access / JET already has built-in!

One of the things that took me by surprise when I began to grasp the
potential is the amazing power of Querys [I suspect that's not Access,
but rather a function of SQL and RDBMs.] I'm fairly certain I'm still
"just scratching the surface" of the power of queries.

--
Clif

"TraciAnn via AccessMonster.com" u50702@uwe wrote in message
news:945b1b0ecc838@uwe...
Wow! I thought I was going to have to do some code in frmCallDetail
like:

Private Sub Form_BeforeInsert(Cancel As Integer)
On Error GoTo Err_Form_BeforeInsert

Me.CallID.Value = Forms.frmCall.txtCallID

Exit_Form_BeforeInsert:
Exit Sub

Err_Form_BeforeInsert:
MsgBox Err.Description
Resume Exit_Form_BeforeInsert
End Sub

I'm glad you guys set me straight!

Clif McIrvin wrote:
In addition to what John said about Master / Child Link fields when
you
have the one to many relationship between the two tables (these are
related tables, right?) set to enforce referential integrity the
linking
is automatic.

--
Clif

I am fighting against the clock to figure out the record creation
concept for
[quoted text clipped - 11 lines]
Master
Link Field fills in automatically into the child link field.


--
---
TraciAnn

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200904/1




--
Clif

On Thu, 09 Apr 2009 17:11:54 GMT, "TraciAnn via AccessMonster.com"
u50702@uwe wrote:

Is it REALLY THAT EASY?!!!

I LOVE ACCESS!!!!

chuckle

Glad to be the bearer of good tidings.
--

John W. Vinson [MVP]