Re: access newbie
From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 07/04/04
- Next message: s.dolson: "Word 2003 Slows down during use; Finally freezes."
- Previous message: John Vinson: "Re: drop down list in invoice"
- In reply to: scott: "Re: access newbie"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 04 Jul 2004 14:53:09 -0600
On Sun, 4 Jul 2004 17:55:26 +0100, "scott" <scott@sporticia.com>
wrote:
>if I was writing this as a web page/sql backend, I would generate x2 sets of
>SQL insert statements, one into the problem table and one into the notes
>table, utilising the pr_number entered
>
>but Access doesn't seem to permit this (it keeps changing my SQL statements
>automatically behind the scenes??), is Access capable of inserting into x2
>tables at the same time from one entry form ?
Typically this would be done using a Form for the main table, a
Subform for the notes table, and the linking field as the master/child
link field. No code needed.
Glad you got it working, even if doing so in a somewhat different
manner!
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
- Next message: s.dolson: "Word 2003 Slows down during use; Finally freezes."
- Previous message: John Vinson: "Re: drop down list in invoice"
- In reply to: scott: "Re: access newbie"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
