By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 1,945 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

Create New Records in Table

P: n/a
I have a form which is based on a table (a) with over 6000 records.I have a
button on this form which will open another form with related data from
another table (b). What I want to do is open the second form and see the
related data or if it hasnt got any related data create a new record in
table (b) so that I can input data.
If possible I dont want to create a one to one relationship between the
tables but create the new records in table (b) when I press the button.
Is this possible or do I have to create a link between the tables on a 1
to 1 basis. I dont really want to do this as the second table(b) will only
have about 1000 records linked to table (a)
Many thanks in advance
Dave
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You can tell the second form about the primary key of the first form
using the OpenArgs parameter of the DoCmd.OpenForm method. Use the
second form's OnOpen event to do some processing depending on the
value passed to it using OpenArgs. Alternatively, you can use the
Where parameter of the OpenForm method to filter the records of the
second form.

Both of these are more work than the 1:1 relation. If you are
concerned about it, a 1:1 relation does not necessarily mean the
second table contains all 6000 records. the 1000 records is perfectly
acceptable.
On Thu, 26 Feb 2004 00:36:43 +0000 (UTC), "Dave"
<da***********@btinetrnet.com> wrote:
I have a form which is based on a table (a) with over 6000 records.I have a
button on this form which will open another form with related data from
another table (b). What I want to do is open the second form and see the
related data or if it hasnt got any related data create a new record in
table (b) so that I can input data.
If possible I dont want to create a one to one relationship between the
tables but create the new records in table (b) when I press the button.
Is this possible or do I have to create a link between the tables on a 1
to 1 basis. I dont really want to do this as the second table(b) will only
have about 1000 records linked to table (a)
Many thanks in advance
Dave

**********************
ja**************@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.