How to Show your Table in a Post

[Uncle Gizmo]

I've done a YouTube Video, showing 3 different methods of posting your table structure to a forum HERE:- MS Access - Copy Table Structure for Forum

Here is a Google Doc showing the first procedure of the three:- MS Access - Copy Table Structure for Forum (First Method)

Here is a Google Doc showing the Second procedure of the three:- MS Access - Copy Table Values for Forum

Here is a Google Doc showing the Third procedure of the three:- MS Access - Copy Advanced Table Structure for Forum

 

[jdraw]

Tony,

Good stuff. Looks great and easy to follow.
If you're looking for suggestions--- how about how to copy your tables and relationships to forum.

 

[Uncle Gizmo]

Something like this jdraw?

Relationships


         tblCondition >>> tblPatientInfo

                          tblCondition                       tblPatientInfo

                    ID                         1     ¥  Condition



                  Attributes:                Enforced
                  RelationshipType:          One-To-Many



         tblRoom >>> tblPatientInfo

                             tblRoom                         tblPatientInfo

                    ID                         1     ¥  Room



                  Attributes:                Enforced
                  RelationshipType:          One-To-Many



         tblWard >>> tblPatientInfo

                             tblWard                         tblPatientInfo

                    ID                         1     ¥  Ward



                  Attributes:                Enforced
                  RelationshipType:          One-To-Many

Actually this would be better:-

Relationships


tblCondition >>> tblPatientInfo (Edit... I added the >>>)

tblCondition tblPatientInfo

ID 1 ¥ Condition



Attributes: Enforced
RelationshipType: One-To-Many



tblRoom >>> tblPatientInfo

tblRoom tblPatientInfo

ID 1 ¥ Room



Attributes: Enforced
RelationshipType: One-To-Many



tblWard >>> tblPatientInfo

tblWard tblPatientInfo

ID 1 ¥ Ward



Attributes: Enforced
RelationshipType: One-To-Many

 

[jdraw]

I was thinking more of
a) expanding the tables in the relationships window to show all fields
b) a screen capture to a named file (.jpg)
c) attaching the file to a post

 

[vbaInet]

Uncle T, good job! Might be worth mentioning that Code tags can actually be typed and there's no need to 'Go Advanced'.

Shouldn't this be a sticky?

 

[Uncle Gizmo]

Jdraw.... That's a good suggestion. I have had a look at the relationship window with a view to explaining a bit about relationships for new users.

I was wondering whether to add information like, to look out for links between tables in a query which do not show up in the relationship window. I'm not sure... I don't want to get it too complicated. I wondered if there's anything else that should be explained about relationships that you or anyone reading come across in posts frequently.

 

[jdraw]

Tony,
I would not focus on the whys and wherefores/ details of Relationships. We could post links to various sources. I have often referred to Rogers Access Library and others..

I would deal with getting the tables and relationships window to a jpg and attach same to a post. I see your topics as copy info to your post on the forum..

 

[Uncle Gizmo]

Yes you're right I am over thinking over complicating things as usual...