Solved: Table within a Table

[Imdabaum]

Okay.. this will prove my ignorance about many features in Access, but How do you make a table within a table? I was just asked to fix a project and one of the tables has Plust signs beside the id which open another table from the Database. How do I actually make a table like that?

[Norie]

Eh, as far as I know you don't 'make' this and it isn't really a table within a table.

It's inbuilt functionality of later versions of Access.

It will happen if you have relationships set up.

For example say you have 2 tables Table1 and Table2.

In Table1 there is a primary key ID and in Table2 that appears as a foreign key.

If there was a one-to-many relationship between Table1 and Table2, then in Table1 you would get the table within table.

[stanl]

If 'plust' sign is really a logical field, then perhaps + is a way of displaying it rather than Yes or checkbox or 1. Then its simply a query of

SELECT * FROM [Field] WHERE plust

as translated to actual data.

If I have read your post wrong then blame it on the fact I just discovered 10 million ants in my house where none were expected. Stan

[Imdabaum]

Thanks I have one more wrinkle in my brain. I didn't think it was any programming because it is a simple table. Most likely just the actual relationship.

[RobertBC]

hope others give you much idea how this happens in addition to that...
table you created like A Master(parent) Table and a Details(child) Table with relationship with one another will allow you to see each record in datasheet view without opening both table.. on the Master table Unique identification number will appear a plus sign on it indicating that record has a child record on it. remeber your relationships?

:friends:

[Imdabaum]

Thank you everyone who saw the post and replied. I am learning a lot as an intern and hope my skills will amount to something when this is done.