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