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. Pulling information from one table/ sheet based on some conditio (1 reply)
  2. Regarding Lookup Fields in Tables (5 replies)
  3. Too many columns in my table. Is there a different way to do thi (5 replies)
  4. how to stop pop-ups "key fields" when linking to Oracle tables? (1 reply)
  5. How do I strip out Tab characters from Memo field? (5 replies)
  6. Bringing in multiple data fields from 1 table (8 replies)
  7. Can the name of a table link be changed? (1 reply)
  8. Created a Column named "Money" (8 replies)
  9. Question revolving around "inventory" DB design (22 replies)
  10. Visibility Of Primary Key Table View (3 replies)
  11. Open Access without entering password (1 reply)
  12. Is there a way to Autonumber by date? (6 replies)
  13. Reversing a one-to-many relationship (13 replies)
  14. Deleting A Table (1 reply)
  15. Number Size Format and Decimals (4 replies)
  16. Attempting to change data type for field but can't because.... (3 replies)
  17. How to Associate 1 New Table with 3 Existing Tables? (1 reply)
  18. Default Value Help (2 replies)
  19. Using XML to append to a linked table (1 reply)
  20. Employee table --> 2 fields in Project Table (5 replies)
  21. questionnaire DB and form setup (1 reply)
  22. Performance (2 replies)
  23. Custom Record Navagation Buttons and Text Box (5 replies)
  24. relinking to deleted link (3 replies)
  25. How can I produce a value when using a combo box (3 replies)
  26. blank foreign key in a related table 'causes an issue (4 replies)
  27. Combine two fields in a table to auto fill another field in same (4 replies)
  28. digits in number format (1 reply)
  29. help with table design (38 replies)
  30. Table linked to a item on a field (18 replies)
  31. Store Image in table (4 replies)
  32. What's wrong with this relationship? (5 replies)
  33. Table is locked (3 replies)
  34. Importing Data (3 replies)
  35. MS Access Linking text fields with various problems (2 replies)
  36. Client ID (autonumber or not) (6 replies)
  37. How to link tables? (3 replies)
  38. Design Table Question (14 replies)
  39. Design for project (5 replies)
  40. field properties (1 reply)
  41. Storing enrishing details in separate table (0 replies)
  42. Multiple Fields depending on circumstances (5 replies)
  43. Incremental table backup or restore (3 replies)
  44. Should Lookup tables have an autonumber? (5 replies)
  45. Field similar to Autonumber (4 replies)
  46. subdata sheet? (3 replies)
  47. Access Tables... (10 replies)
  48. Changing fields (7 replies)
  49. Restoring an AUTONUMBER field (3 replies)
  50. Delete Table with VBA (2 replies)
  51. Calculated Controls (7 replies)
  52. Naming of Field (5 replies)
  53. Help again to the lovely people out there:) (2 replies)
  54. How to create an ODBC link for Access (6 replies)
  55. Multiple relationships to a parent and linked tables (3 replies)
  56. Delete field though VBA (14 replies)
  57. Creating an Archive Table (1 reply)
  58. Best design for 2 or 3 linked tables... (3 replies)
  59. Help with this issue (3 replies)
  60. Image Database (5 replies)
  61. What does Normailization Say about Multiple Tables When Not all (4 replies)
  62. Force Access to accept date its being given correctly. (4 replies)
  63. Make Database read only (5 replies)
  64. Can't 'find' field in linked table (2 replies)
  65. Are my relationships right? (9 replies)
  66. ToDoList database design (26 replies)
  67. Maximum Text Field Size Not Sufficient (7 replies)
  68. Link tables ODBC dialog not working (9 replies)
  69. Changing Field Type on Existing Table (1 reply)
  70. Opinion(s) requested on a design question (1 reply)
  71. Referential Integrity? (8 replies)
  72. resource allocation... is it possible? (3 replies)
  73. Table relationships defined but records won't update (10 replies)
  74. Does this structure look normalized? (3 replies)
  75. 2-way relationship? (3 replies)
  76. Maximum table size (3 replies)
  77. Linking To an FTP site (0 replies)
  78. Time Format Problems (8 replies)
  79. Three table layout (3 replies)
  80. Update a table from another table (8 replies)
  81. merging fields (11 replies)
  82. feedback on tbles (31 replies)
  83. compact and repair - not setting primary key to consecutive orde (4 replies)
  84. data format (6 replies)
  85. Linking Tables between databases (6 replies)
  86. Not sure where to go from here (1 reply)
  87. Calculating a totals field (10 replies)
  88. Name from table placed on switchboard (4 replies)
  89. Join Properties (4 replies)
  90. Time table? (2 replies)
  91. Last Updated Column (3 replies)
  92. Linking 3 tables correctly (normalized) (9 replies)
  93. my table with all fields datatype set to "text" (5 replies)
  94. which table structure makes more sense? (5 replies)
  95. how many tables would this take? (4 replies)
  96. Many-to-one relationship (2 replies)
  97. Creating a 1:1 relationship (3 replies)
  98. Relationships with Split Databases (3 replies)
  99. Test-Like DB (1 reply)
  100. Survey Responses (14 replies)
  101. Not sure what area to learn to solve my problem (8 replies)
  102. Automatic ID Codes from Name Fields (3 replies)
  103. Composite/Dual Key & Autonumber Problem (18 replies)
  104. How to convert mdb to MySQL (2 replies)
  105. Invalid Field Definition (1 reply)
  106. Too many fields to import (6 replies)
  107. Counting copies (1 reply)
  108. Import date problem from excel (1 reply)
  109. Relationship Check up (3 replies)
  110. error displayed? (3 replies)
  111. DB Structure Question (4 replies)
  112. Making an Append Query work (14 replies)
  113. Newbie needs importing help (1 reply)
  114. INSERT INTO Syntax error (3 replies)
  115. Help - Initial Design (1 reply)
  116. Checking if an existing table is empty (3 replies)
  117. LDB table file (13 replies)
  118. Want to get some feedback on proposed design denormalization. (6 replies)
  119. Build a one-to-many table from record with index and many fields (6 replies)
  120. Problems with Junction table (1 reply)
  121. Auto-reading from excel (6 replies)
  122. Deletions (4 replies)
  123. Archiving Records (3 replies)
  124. Preventing updates in a linked table (3 replies)
  125. autonumbers and input masks (3 replies)
  126. Am I on the right track? (1 reply)
  127. Relationship examples (2 replies)
  128. Query running when I open an Access Table (1 reply)
  129. How to "logically" link a whole table for each record ? (8 replies)
  130. Sharing tables (10 replies)
  131. storing a formula's result from a form in a table field... (3 replies)
  132. Joins & Cascading Updates (1 reply)
  133. Any way to convert CSV? (6 replies)
  134. Stuck Modelling medical table relationships (8 replies)
  135. Having Trouble (6 replies)
  136. Foreign Keys/Relationships Issue (using SQL) (2 replies)
  137. Number Data Types (8 replies)
  138. Problem with synchronization (1 reply)
  139. Access Front-end - SQL Backend - Relationships (5 replies)
  140. Adding a value to a current field in a table and refreshing it (1 reply)
  141. Suggestion on table structure for Access db (3 replies)
  142. Brand New - Help Required (6 replies)
  143. Editing Import specifications (3 replies)
  144. Can Number Field Perform Functions? (25 replies)
  145. Leading Zeros - Input Mask (8 replies)
  146. Creating copies of fields (7 replies)
  147. Table structures and normalizing of new database (9 replies)
  148. Update giving error (1 reply)
  149. Creating a Medical db based on paper forms (4 replies)
  150. Updatiing fields in a table (5 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.