Re: Auto-Poulate a Value in a Table

I will try to clarify further... I want the policy number to transfer to the
new record instead of the records policy number being the default NULL.

For instance the policy number is 5, I click add additional insured button,
brings me to a blank form to update the table but with the policy field
already having the value of 5.

"Jeff Boyce" wrote:

It sounds like you are saying you want an empty (?dummy?) record created in
table2 when you create a new record in table1. Why?

In Access, you typically would not need or want to create a new record in
any table until you had data to put in it.

Also, in Access, you would typically handle creating one/more related
records in a "child" table (your [AdditionalInsured]) by using a main form
(displays the [Policy] info)/sub-form (displays any/all [AdditionalInsured]
info) construction. This way, Access would handle adding the necessary
[PolicyID] to the child table, but only when you need to add a record.

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

"Kerensky18" <Kerensky18@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1ED74D8B-4503-4BF5-9065-F177E76DEAB3@xxxxxxxxxxxxxxxx
Hello Again;

I have another issue that I can't figure out. I'm designing a Insurance
database for class and am having issues with two tables.

The two tables are Policy and Additional Insured.

Policy is tied to Additional insured via policy ID.

What I would like to happen is the user clicks on a button in Policy(form)
called Add Additional Insured. I want this button to open up the
Additional
Insured(form) to a blank record and auto-populate the Policy ID #. Is it
possible to do this?



.