Trouble Saving Sub Data Sheet Name

[raward1941uk]

Hi

I always feel as though I'm asking a stupid question but here goes. I am making a database with sub tables and sub forms, and working from "Access 2003 inside out". When I open table properties and enter a subdata sheet name and fill in child and master links everything seems fine until I try to save it. I open the table properties window again and the sub data sheet option has returned to "auto". Am I doing something stupid or is there a bug in my system?

 

[neileg]

Sub tables are very much more trouble than they are worth. It is better to use ordinary tables and link them in a form/subform setup or a combo box depending on the nature of the sub table.

 

[raward1941uk]

Thanks

Thanks; I've come to the same conclusion, I've changed link now and the subtable is coming up but looking in the properties menu the sub table is set to auto.

I'm on a very steep learning curve but enjoying it!

Cheers

Roger Ward