How to Show your Table in a Post (1 Viewer)

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

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.

Something like this jdraw?





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

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

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?

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.

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..

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