Full Version: Access Tables + Relationships
UtterAccess Discussion 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, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128
  1. My 'make table query' table isn't showing correctly (3 replies)
  2. When I copy access database on my desktop, it updates the original (3 replies)
  3. Creating a Schedulng Database (4 replies)
  4. Code to set a query to be hidden (5 replies)
  5. store folder (18 replies)
  6. Unlocking a table (5 replies)
  7. Autonumber (6 replies)
  8. Import data into split database (3 replies)
  9. Slow - even a tiny linked table (3 replies)
  10. Access 2007 continually locks up after table field type change (4 replies)
  11. Index Multiple fields (3 replies)
  12. Change table data type (3 replies)
  13. Using number- or text-field as primary (3 replies)
  14. Listboxes Values Determined By Value Within Same Table (9 replies)
  15. Store a search string or not? (6 replies)
  16. VBA to Remove Table Links (1 reply)
  17. Design of table or Query (5 replies)
  18. Temp Tables (4 replies)
  19. Relationships (5 replies)
  20. Problem with SQL tables (4 replies)
  21. Tables, Tables, Tables (13 replies)
  22. Access Permissions (2 replies)
  23. Link Table (1 reply)
  24. Attachment or Hyperlink? (2 replies)
  25. table custom index (14 replies)
  26. Where is Column History Stored and Can it be modified and How? (3 replies)
  27. Linking fields mathmatically (3 replies)
  28. I used to know how to do this... (4 replies)
  29. Sorting information based on 2 tables...query? (1 reply)
  30. Calculations in my form don't show up in the underlying table (3 replies)
  31. Automated Table drop/creation (5 replies)
  32. "Type Mismatch" error when sorting (14 replies)
  33. Referencing ID numbers to display names (1 reply)
  34. forms and sub-forms, passing fields (1 reply)
  35. Linking a Spreadsheet to DB (6 replies)
  36. Retaining Past History When Data is Changed (6 replies)
  37. Junction table relationships (4 replies)
  38. Data Traking data base - survey data (3 replies)
  39. Question about a many to many relationship setup and the form (17 replies)
  40. Inserting into Multiple Tables (4 replies)
  41. Autofilling Forms Using Data From Other Tables (7 replies)
  42. Set a Primary Key when Linking in VBA (5 replies)
  43. Yes/No relationship (11 replies)
  44. Table relationships (8 replies)
  45. Tables which can update and then save into another table (1 reply)
  46. Save a value to a table more simply than DAO? (5 replies)
  47. Merge records (1 reply)
  48. Linking tables in separate databases on different networks (5 replies)
  49. Create one to one relationships in relationship window (13 replies)
  50. One Relationship Not Acting Like the Others (1 reply)
  51. Archive Table (11 replies)
  52. Tables and “all data query” ID problem (1 reply)
  53. Using temp tables on related tables - having some horrid problems (24 replies)
  54. many entries for a single item (2 replies)
  55. The right fields and tables ( individual machines) (10 replies)
  56. Access Linked to Text File (7 replies)
  57. Joined Fields (4 replies)
  58. Tables / relationships / form generation (6 replies)
  59. Incrementing field automatically from code. (7 replies)
  60. Remove blanks (2 replies)
  61. Joining of tables (4 replies)
  62. Setting hierarchical lookups in tables (3 replies)
  63. Tables & Relationships (1 reply)
  64. Input mask - only characters and no spaces (5 replies)
  65. Update Table Name Without Updating Queries, etc (3 replies)
  66. Structure - modify contact management template? (1 reply)
  67. Bingo database help! (10 replies)
  68. Lookup Product Code and Return Details (12 replies)
  69. Can't go into design on a table (3 replies)
  70. Vanishing Relationships (4 replies)
  71. Sum of two fields in the same table (12 replies)
  72. How to do this? (3 replies)
  73. Advanced Lookup Field Help (5 replies)
  74. Why shouldn't Lookup fields shouldn't be used in tables? (5 replies)
  75. Relationships (7 replies)
  76. Keeping track of field changes (2 replies)
  77. Equipment with Maintance History (6 replies)
  78. find (2 replies)
  79. Unary relationship creates new challenges for relationships and queries (1 reply)
  80. Autonumber field (5 replies)
  81. What would cuase a value in a record to round automatically in a certain field? (2 replies)
  82. saving a 2007 to an 03 (3 replies)
  83. Renaming table from Listbox (5 replies)
  84. Updating Materials List Table (3 replies)
  85. Enter new records (3 replies)
  86. Difference bet 2 date/time values (3 replies)
  87. Auto numbering (25 replies)
  88. Help designing table (3 replies)
  89. AutoNumber, Resetting Seed... SQL Backend. (7 replies)
  90. Does querying a linked table less fast ? (1 reply)
  91. Relationship Assistance (1 reply)
  92. Relationships for contacts and estimates (15 replies)
  93. any possible downside of having a persistent connection? (6 replies)
  94. Naming Schemes (10 replies)
  95. Access 2007, Display Foreign Data in Form (8 replies)
  96. My Dilemma: Junction Table Ignorance (7 replies)
  97. data type long... overflow 6.... 32,767 (1 reply)
  98. Relationship between request and order (2 replies)
  99. Assign a subdatasheet to a table that is a query (5 replies)
  100. Fake Clustered Index? (3 replies)
  101. membership dbs (4 replies)
  102. Confidence is spiraling, Need serious Relationship/Normalization help! (13 replies)
  103. Replacing Field data (3 replies)
  104. Name AutoCorrect on Split Database (7 replies)
  105. Records not Appending (7 replies)
  106. Troubles making new field with criteria. (2 replies)
  107. relinking tables (1 reply)
  108. Update Table when no record found! (1 reply)
  109. Database Design and Problems... Stumping actually... (3 replies)
  110. Table design for a pricing platform? Need suggestions :) (15 replies)
  111. Add new fields to existing table - Automatically (2 replies)
  112. Create List of Table Field Properties (7 replies)
  113. Creating a structure for materials tracking (20 replies)
  114. Shape file dbf import/link (3 replies)
  115. Normalizing and Transferring Data (9 replies)
  116. Bringing up Access performance by seperating out table databases (specific issue!) (21 replies)
  117. Recordset (2 replies)
  118. Newbie Normalization Question (12 replies)
  119. Linked table Error (4 replies)
  120. Data Storage (7 replies)
  121. New Project! Advice Please (1 reply)
  122. Not all Joined tables in relationship window appear as subdata sheet automatically (11 replies)
  123. How can I update/change the reference paths for a database? (4 replies)
  124. multiple instances of same table (1 reply)
  125. Add fields to tables using a form? (12 replies)
  126. linked sql tables (11 replies)
  127. Moving table rows from one database to another database (5 replies)
  128. seperate tables or not? (3 replies)
  129. too many fields..is one to one relationships of (1 reply)
  130. creating a table from frequenlty used query (2 replies)
  131. Temporary Dbase and Tables - What and how? (7 replies)
  132. Design question (7 replies)
  133. Primary and Foreign Key values (3 replies)
  134. Creating a Student Database (3 replies)
  135. one to one vs one to many? (6 replies)
  136. How to use a field in a query from an non-related table (4 replies)
  137. Values in one field depending on another (3 replies)
  138. Audit Log HELP (4 replies)
  139. Creating a new project and want it to be dynamic as possible (Any tips or examples on (6 replies)
  140. Creating a personal autonumber field (1 reply)
  141. Relationship/Join help (18 replies)
  142. need advice on normalization (11 replies)
  143. Importing unusual table (4 replies)
  144. Insert Record ID (7 replies)
  145. Table Structure (10 replies)
  146. Importing old data (3 replies)
  147. Dmax Function Please (4 replies)
  148. How do you store OS Enviroment varibles? (6 replies)
  149. Purchase orders (5 replies)
  150. need advice on database make up (6 replies)
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.