Subdatasheet ????

[Parra]

In a table with a one to many relationship. A column appeared with a little "+" sign.

How the hell do I delete that stupid thing. Its annoying!!!!

Parra

 

[SydneyGeek]

I'm not sure you can delete it per se, but check the Table properties when you are in Design view.
It can actually be helpful -- you can assign any related field to the subdatasheet.
But I have a question -- why are you mucking about in the table anyway?
As a matter of course, I provide data entry forms for any table / query. That way you have more control over the user's behaviour and can apply validation and automatic calculations to your data.

 

[Parra]

Hi SydneyGreek,

I was designing the database and deleted a table and then when I clicked on the stipid little "+". I had to link it to something. I don't know if this will effect the queries or forms, I hope not, or is more for cosmetics.

By the way I have a Greek friend living in Australia, you would'nt happen to know "Niko" would you?

Parra

 

[SydneyGeek]

Hi Parra,

Don't worry about the subdatasheets -- cosmetic only. Like I said, tables are for holding the data and not for playing with it

And no, sorry I don't know Niko. There's 19 million Aussies spread across an area the size of the continental US...