Full Version: Access Tables + Relationships
UtterAccess Forums > Microsoft® Access > Access Tables + Relationships
Pages: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69
  1. Key - unique combination of 3 fields (6 replies)
  2. Trying to Understand Normalization to the 3NF (1 reply)
  3. ODBC Table Link - Read Only (2 replies)
  4. Looking for Recommendations on split tables (3 replies)
  5. Relationship Design for Real Estate Company (3 replies)
  6. Advice on table setup (3 replies)
  7. Import Excel 2003 Spreadsheet into Access Table (3 replies)
  8. Table in BE (3 replies)
  9. Autonumber Out of Sequence (4 replies)
  10. Archiving a detail table and Indexing (14 replies)
  11. Don't want table to autopopulate (3 replies)
  12. Synchronising field name changes in front end and back end (4 replies)
  13. creating tables in a backend mdb (oh,, and then linking to them) (7 replies)
  14. Decimals exporting on number field when I don't want decimals (2 replies)
  15. Locking of database (1 reply)
  16. autotext (3 replies)
  17. Autonumber/Username (concerning PK) (1 reply)
  18. primary key automatically loaded? (1 reply)
  19. Relationship building between one field and four fields in anoth (8 replies)
  20. Converting Number to text or Vise Versa (3 replies)
  21. many-to-many relationship (1 reply)
  22. Autonumber got lost (5 replies)
  23. Internal hyperlink insertion facility disabled (8 replies)
  24. Scheduling Demo (4 replies)
  25. Error 2387 Can't delete the table.... (4 replies)
  26. Sorting a Table with VBA (5 replies)
  27. How to remove dsn's from the list of ODBC machine sources (10 replies)
  28. Table One Record (10 replies)
  29. Locking all records from editing in table (5 replies)
  30. Linked tables (3 replies)
  31. Table deleted (1 reply)
  32. Compare two tables (30 replies)
  33. Removing unwanted text from data in a linked SharePoint table (4 replies)
  34. Populating a field via a reference table (1 reply)
  35. Unable to export table structure only with docmd.TransferDatabas (2 replies)
  36. Deleting Phone numbers (11 replies)
  37. Adding Fixed Elements to Calculated Fields (3 replies)
  38. Tracking Training table layout (5 replies)
  39. One table to store all contact types (7 replies)
  40. Changing the data in one field in a table (3 replies)
  41. Default value based on a Yes/No Field (3 replies)
  42. Relationships (1 reply)
  43. Table not related to anything. OK? (3 replies)
  44. Trying to figure out how to keep things seperate. (Beginner) (2 replies)
  45. Normalization and a One-to-One Relationship Problem (2 replies)
  46. Record Won't delete (7 replies)
  47. Please review my relationships and queries (6 replies)
  48. Saving multi select values to the table (10 replies)
  49. Creat a fields from an existing table (1 reply)
  50. Too many fields in a table (3 replies)
  51. link tables on by servername vs drive name? (3 replies)
  52. data in one table creating default info in another (1 reply)
  53. Table above the toolbar on Relationship View (3 replies)
  54. How do I combine to columns to form a Hyperlink (6 replies)
  55. Hidinh Columns (8 replies)
  56. Normalizing My DB – "DOB" Goes In What Table? (5 replies)
  57. Subdatasheets Question (6 replies)
  58. Cannot copy table in Access 2000 (7 replies)
  59. Importint data from XML (1 reply)
  60. Linking Tables Using the Server Name instead of Drive Letter Whe (3 replies)
  61. Trailing Spaces in Table Fields Won't Go Away (7 replies)
  62. Create Index via VBA Code (15 replies)
  63. TempMSysAccessObjects (1 reply)
  64. Split Database very slow from remote locations (2 replies)
  65. a relationship question (7 replies)
  66. preventing double booking question (2 replies)
  67. help on queries (4 replies)
  68. My tables wont play ball ! (3 replies)
  69. Subdata sheets with Linked tables (1 reply)
  70. Insert Table query syntax error (3 replies)
  71. Create Auto ID That Incorporates Date As New Entry (8 replies)
  72. Relationship question (3 replies)
  73. Compact/Repair db - error message (1 reply)
  74. hour glass , very slow saving data (1 reply)
  75. ALTER TABLE problem with data type HYPERLINK (3 replies)
  76. setting an incrimental default value (3 replies)
  77. Auto Numbers on tables. (4 replies)
  78. duplicate numbers... (1 reply)
  79. linking fields with partially matching entry’s eg. “H Ltd” to “H (1 reply)
  80. list all tables and related fields in tabular form (7 replies)
  81. Exporting a table from Access to excel (1 reply)
  82. Relationships (37 replies)
  83. Userid as defualt value in Access 2003 table (1 reply)
  84. Joining tables that are normalized (5 replies)
  85. Create Field Using SQL by looking up Field Name (1 reply)
  86. Access bombs while code executes (5 replies)
  87. dual index on a primary key (8 replies)
  88. Setting Up Tables and Relationships (1 reply)
  89. Organizational Question For Data (8 replies)
  90. Select all Records in a Table (9 replies)
  91. General Relationship Question... table updates? (2 replies)
  92. Relationship Problem I'm lost (12 replies)
  93. Update date on table (15 replies)
  94. Problem deleting records -- lock violation (1 reply)
  95. Relationships and Tables... Companies and Departments - Multiple (5 replies)
  96. Tables and Primary Keys (2 replies)
  97. Linked Tables & Exclusive Access (4 replies)
  98. Date Table Database Set-Up (6 replies)
  99. Linking a Combo Box with a Set of Values (4 replies)
  100. Extracting tables (4 replies)
  101. Lookup fields (4 replies)
  102. Add two columns in a Query.... (1 reply)
  103. Hyperlinks (1 reply)
  104. Trouble with Memo Fields (auto enter?) (1 reply)
  105. Leading Zero in Numeric field (6 replies)
  106. importing spreadsheets or text files with extra header lines (10 replies)
  107. Validations (8 replies)
  108. Itemized invoices. (8 replies)
  109. Add two columns.... (4 replies)
  110. Carry or start again? (4 replies)
  111. Sorting Alphanumeric (2 replies)
  112. Linked access table isn't in sync with source (6 replies)
  113. Overflow when attempting to link to CSV file (7 replies)
  114. Autosequence Number.... (4 replies)
  115. Replacing a linked table (4 replies)
  116. Become a Better Data Modeler (2 replies)
  117. Deleting old records from mulitple databases (5 replies)
  118. 'Filter By Form' alternatives...? (2 replies)
  119. Invalid Use of Null when trying to add records via VBA (2 replies)
  120. Question regarding relationships (2 replies)
  121. Yet another Survey structure (14 replies)
  122. Limit type of access to linked table (5 replies)
  123. Populate Table with File names and Paths (12 replies)
  124. DAT File to CSV then into Access (5 replies)
  125. Date Issue on Import into a table (9 replies)
  126. Linking Databases (1 reply)
  127. Getting Reference Table and Association Table to work right (9 replies)
  128. New to Normalization (12 replies)
  129. Removing A Field In A Table Using Alter (4 replies)
  130. Table Design (4 replies)
  131. Un-splitting a database (3 replies)
  132. Sorting A Table (3 replies)
  133. Passing the date as the name of a field (4 replies)
  134. Creating a new database based on a spreadsheet design structure. (2 replies)
  135. ODBC Connection Success - Unable to Link to SQL DB (4 replies)
  136. Question regarding transactions (8 replies)
  137. UnLinking Table (1 reply)
  138. An SQL left Join required (I think) (1 reply)
  139. Why not able to get to linked SQL table from Workgroup PC (5 replies)
  140. Can't add column to existing back-end table (3 replies)
  141. How to stop table from updating automatically (2 replies)
  142. Linked table manager shows 'this folder is empty' (1 reply)
  143. performance issues with large number of data elements in one tab (2 replies)
  144. Split import of text file into two tables (1 reply)
  145. Field format (8 replies)
  146. Table/Query Layout Multiple Columns Issue (9 replies)
  147. db relations / query (10 replies)
  148. Spaces in field (4 replies)
  149. Help with filling information into a table (2 replies)
  150. New to Access:: Best relationships for Form with subform. (33 replies)
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.