StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
1554535
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2009-10-12T13:19:21.347
FavoriteCount
0
LastActivityDate
2009-10-12T13:19:21.347
LastEditDate
LastEditorUserId
0
OwnerUserId
185724
ParentId
1532435
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
Thanks for all the info here. It is great info and I would use it as I am self-taught. The easiest way I found as alluded to here, is to use an index on all the fields I want (with No Duplicates). The trick here is really to use multiple indexes (this basically allows a compound index, or a "virtual" index which is made up of more than one field). The method can be found here: <a href="http://en.allexperts.com/q/Using-MS-Access-1440/Creating-Unique-Value-check.htm" rel="nofollow noreferrer">http://en.allexperts.com/q/Using-MS-Access-1440/Creating-Unique-Value-check.htm</a>, but I would repeat it in the event that the link gets removed. From Access Help: Prevent duplicate values from being entered into a combination of fields Create a multiple-field index using the fields you want to prohibit duplicate values for. Leave the Indexes window open when you have finished defining the index. How? <ol> <li>Open the table in Design view.</li> <li>Click Indexes on the toolbar.</li> <li>In the first blank row in the Index Name column, type a name for the index. You can name the index after one of the index fields, or use another name.</li> <li>In the Field Name column, click the arrow and select the first field for the index.</li> <li>In the next row in the Field Name column, select the second field for the index. (Leave the Index Name column blank in that row.) Repeat this step until you have selected all the fields you want to include in this index. The default sort order is Ascending. Select Descending in the Sort Order column of the Indexes window to sort the corresponding field's data in descending order.</li> <li>In the upper portion of the Indexes window, click the new index name.</li> <li>In the lower portion of the Indexes window, click the Unique property box, and then click Yes.</li> </ol> You should now be able to not enter records which have the same values in the indexes. I got problems where I could still enter values if one of the indexed fields has a space (there is an option to check/ignore null values when you set up the index) but it didn't work for me, but the solution worked because I won't have null values anyway.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POAdd record only if doesn't exist in Access 2007
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USV.K.
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.