Relationer - oprette felt

Your diragram or explanation doesnt say WHAT you are trying to update! Can you give a better explanation?

Also, I'm puzzled as to why Main.MainID (primary key) is related to Menu.MenuID (also primary key) You could just as well have the information in Main in the Menu table!

Main(MainID) indhold skal over i Menu(MenuID)
Main(Head) indhold skal over i Menu(Head)

Det ville været nemmeste med auto-update, fremfor at jeg skal skrive det samme flere steder/oprette 2 poster hver gang...

nogetfx>You still need to give an explanation which we can undertstand, otherwise we cant help!

WHAT do you want to update?

You can NOT update two tables at the same time just because they are related!

If you want to write a new record in Menu after you have written a record in Main then you MUST also write a new record yourself, it CAN NOT be done automatically!

But I still can NOT see why you need two tables! If Main.MainID is the same as Menu.MenuID and Main.head is the saem as Menu.Head then you could just as well move Main.Text to Menu.Text (new field)

?

!

Beklager. troede at jeg havde lukket det...

Grunden til jeg vil have to tabellerer er for at reduceere størrelsen = ikke for mange felter. Men hvis jeg selv skal op-/rette hver gang kan jeg lige så godt gøre det via ASP. Takker for dine kommetare...

Ups.. hehe Smid et svar. Jeg ville acceptere dit svar, som tak for dine bud--

:o)

A table in Access can have 255 fields!

Jaja, men 255 felter begynder at slide lidt på hastigheden.. hehe

so does having to JOIN your tables in a query :o)