Add a detail (child) record

[grahamea]

Hello,

I've been tasked to create a database for my wife's work and can only use Access 2000. I've created the db schema and populated lookup tables ok but am having trouble adding detail (child) records to a master (parent) record.

For simplicity's sake here's the schema:

foster_carers
===========
foster_carers_id
reference

carer
=====
carer_id
foster_carers_id (FK to foster_carers)
name

I've created several foster_carers and have manually added some carers but I want to present the forms to the user.

My three forms are:

frm_foster_carers_details - foster carers details
sub_foster_carers_carers - sub form showing some carer details for all carers for the foster carers
frm_carer_details - carer details

My frm_foster_carers_details correctly shows it's carers (via sub_foster_carers_carers). But I'm having problems adding/editing carer records.

1) How can I open the form frm_carer_details to add a new record with carer.foster_carers_id prepopulated (and unchangable)? and

2) Open the frm_carer_details form so I can edit the currently selected (or double-clicked) carer?

Any help would be much appreciated.

Cheers,

Grahame

[FishVal]

Hi, Grahame.

Look at LinkChildFields and LinkMasterFields properties of the subform control.

Regards,
Fish.

[NeoPa]

Fish's response should get you going, otherwise the wizard should create this for you if you use it.
Good luck with your project :)

[grahamea]

Thanks both of you for your speedy responses.

In my plan to make my description simple I forgot to mention that the subform only shows partial details while the frm_carer_details form shows everything for a carer.

What I'm wanting is a way to add (and edit) a carer via the frm_carer_details form. If I double-click (for editing) a carer in the subform is there a way to display the details form? Likewise if I press the * (new record) in the subform can I show the details form?

While we're on it, how do you delete records? Select a record and press Delete?

I'm sure there are thousands of databases with similar functionality but I just can't figure it out.

Sorry for not explaining myself earlier.

Cheers,

Grahame

[FishVal]

Ok.

That much more clearer. You just need to open the form filtered by carer (to point it to the same record as in the subform) with DoCmd.OpenForm method and set DefaultValue property of FK field to the value of FK field in the subform (or PK field in the main form) to emulate linked subform behavior.

I guess you may find interesting Add Matching Record on Filtered Form thread closely related to your issue.

Regards,
Fish

[grahamea]

Ok.

That much more clearer. You just need to open the form filtered by carer (to point it to the same record as in the subform) with DoCmd.OpenForm method and set DefaultValue property of FK field to the value of FK field in the subform (or PK field in the main form) to emulate linked subform behavior.

I guess you may find interesting Add Matching Record on Filtered Form thread closely related to your issue.

Regards,
Fish

Fish,

Thanks for that - I'll see if I can give a whirl tonight when I finish work!

Cheers,

Grahame