Main & Sub datasheet på form

Not quite sure what your saying.

If you have cascade updates/deletes switched on between the main/sub tables then if you alter the primary key in main it will automatically get changed in the sub table.

What do you mean by ?
"kan jeg åbne/lukke for view/indtastning direkte i subtabel"

Entering data into the sub table has nothing to do with cascade delete/update!

"... hvordan gøres dette .... "
The same way as you normally would, with a main/sub form configuration.

Or maybe you need to explain a little more.

Hi Terry

The two tables both have 5 primary keys relating to each other, and those are updated in automatically in the subtabel.

The main table have 1 record per product ID per Year, but the subtable have 1-5 individual salesprices per product ID per year. This is where the "one to many" relation are.

The user should have the possibility to create/update/delete a product in the main table, and add the individual salesprice in the subtable using one userform.

Not quite sure I get that.

The two tables both have 5 primary keys relating to each other, and those are updated in automatically in the subtabel.

This I understand
The user should have the possibility to create/update/delete a product in the main table, and add the individual salesprice in the subtable using one userform.

and I would have a main form for the main record and a sub form for the sub records (salesprices)

Maybe seeing the dB (or example) would help explain.

main form contains sub form so to user looks like one form

Can I send you an E-mail to explain my self ?

ekspertenATsanthell.dk
AT = @

Lots of details please :-)

I'll be away for an hour or so ...

No hurry :-)

Example sent

thanks Lasse

You´re welcome - your help is highly appreciated