Populating tables on entry to another table

[Inijjer]

Hi,

I've got a working database with pretty good structure etc. one thing I can't figure out is how I would go about creating 3 prepopulated records on a many side of a relationship on entering a new record in the one side of the relationship. Any pointers?

 

[plog]

VBA. Hopefully you are using a form to enter your data. When that record is added, use VBA to run some SQL to insert 3 new records into your other table.

 

[Pat Hartman]

with pretty good structure etc

Doesn't sound like it to me. Why are you duplicating data or creating empty records?

 

[Inijjer]

The one side is contract. The many side are claims. Each contract will have 3 claims. Is there a better structure to reflect this ?

 

[Pat Hartman]

Since the claims haven't happened yet, how do you know how to populate them?

 

[Inijjer]

There are trigger dates for each one. These are determined by the start of the contract and the length of the contract (all field in the original contract table). I'd prefer them prepopulated as waiting to be received so I can log various details of the claim as they come in.

I should be able to run queries on which claims are outstanding for which contract.

 

[Pat Hartman]

Look up the DAO AddNew method for an example.