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
  1. DoCmd.CopyObject table Linked to Local help! (8 replies)
  2. Relationship between to diffrent fields? (10 replies)
  3. Single or multiple tables (10 replies)
  4. Filling text boxes with data after user selects from combo box (14 replies)
  5. Get the field type of a primary key field (9 replies)
  6. Make a copy of a table in backend using VBA (4 replies)
  7. Relationships problem (36 replies)
  8. Can't force Text datatype in linked Excel table! (5 replies)
  9. Homegrown synchronization of table data (4 replies)
  10. Find the primary key of a table using DAO (6 replies)
  11. relationship not possible (5 replies)
  12. Regarding Lookup Fields in Tables (5 replies)
  13. Created a Column named "Money" (8 replies)
  14. Question revolving around "inventory" DB design (22 replies)
  15. Reversing a one-to-many relationship (13 replies)
  16. Employee table --> 2 fields in Project Table (5 replies)
  17. Custom Record Navagation Buttons and Text Box (5 replies)
  18. Combine two fields in a table to auto fill another field in same (4 replies)
  19. help with table design (38 replies)
  20. Table linked to a item on a field (18 replies)
  21. Client ID (autonumber or not) (6 replies)
  22. Design Table Question (14 replies)
  23. Access Tables... (10 replies)
  24. How to create an ODBC link for Access (6 replies)
  25. Delete field though VBA (14 replies)
  26. Image Database (5 replies)
  27. ToDoList database design (26 replies)
  28. Maximum Text Field Size Not Sufficient (7 replies)
  29. Link tables ODBC dialog not working (9 replies)
  30. Referential Integrity? (8 replies)
  31. Time Format Problems (8 replies)
  32. merging fields (11 replies)
  33. feedback on tbles (31 replies)
  34. Calculating a totals field (10 replies)
  35. Join Properties (4 replies)
  36. Survey Responses (14 replies)
  37. Composite/Dual Key & Autonumber Problem (18 replies)
  38. Invalid Field Definition (1 reply)
  39. Too many fields to import (6 replies)
  40. Making an Append Query work (14 replies)
  41. LDB table file (13 replies)
  42. Number Data Types (8 replies)
  43. Can Number Field Perform Functions? (25 replies)
  44. changing font color for just one column in a table (6 replies)
  45. ot calculation (28 replies)
  46. excel sheets into one access table (10 replies)
  47. Backing-up database (9 replies)
  48. Normalized DB (11 replies)
  49. 'Numeric Field Overflow' error on text file import (15 replies)
  50. Locked Table (6 replies)
  51. VBA command to access field names from open table (10 replies)
  52. Are self referencing relationships a Bad Thing? (3 replies)
  53. Defaulting new record information from existing record (10 replies)
  54. OLE Objects (19 replies)
  55. Synchronize drawings (8 replies)
  56. db structure. (18 replies)
  57. With The Help Of Everybody I'm Making Progress!!!! (19 replies)
  58. Quote Generator (2 replies)
  59. Autonumber (9 replies)
  60. DB2 ODBC Driver (4 replies)
  61. How do i normalize this? (12 replies)
  62. Table Structure for appointments (6 replies)
  63. So many problems with design that my head hurts!! (18 replies)
  64. Implementing User-defined Fields - New Table? (14 replies)
  65. Church Membership Database (7 replies)
  66. Database Structure (14 replies)
  67. Writing conflict on SQL Server linked table (5 replies)
  68. SQLexe statement to add AutoIncrement ID as key to a table (7 replies)
  69. Change Linked Table Path By Code (8 replies)
  70. Using a junction table (28 replies)
  71. Relationships logic (15 replies)
  72. Very Ugly Data (25 replies)
  73. Quote DB; Help with design and layout (10 replies)
  74. Database Design (27 replies)
  75. How to determine when back-end file has been updated (6 replies)
  76. Re-designing a db - Please critique (7 replies)
  77. Combo Boxes - Primary key & text for form use (13 replies)
  78. Database Documenter question (5 replies)
  79. Create an automatic text PK (11 replies)
  80. I'm new to access and its sending me mad! (9 replies)
  81. 1.01 = 1.00 ... What the? (8 replies)
  82. timesheet model / methodology (3 replies)
  83. Junction Table not working (8 replies)
  84. Project Management Relationship/Tables... (3 replies)
  85. loading a memo field from an external source (13 replies)
  86. Right align currency field (11 replies)
  87. create a primary key in an existing table that currently does no (4 replies)
  88. Yes / No fields and number fileds (13 replies)
  89. Lookup Value (6 replies)
  90. Unlocking a locked linked table (3 replies)
  91. Lookup table, or Relationship?? (28 replies)
  92. Input Masks (4 replies)
  93. Creating a hyperlink field in a module (7 replies)
  94. Autonumber corruption and table recreation (7 replies)
  95. From Concept to Practice (11 replies)
  96. foreign key (8 replies)
  97. composite keys - to foreign keys (10 replies)
  98. error- property value is too large (3 replies)
  99. Linking with Code (7 replies)
  100. Linked Table: Possible to make it read only? (4 replies)
  101. Another relationship suffers from my inexperience (17 replies)
  102. New User needing help with 1st time design of sales/commission d (10 replies)
  103. Normalized structure and data entry... (11 replies)
  104. primary key must be numerical? (27 replies)
  105. Problem with table design for Tree of Diagnosis (16 replies)
  106. Relationships and Normalization Help, Please. (9 replies)
  107. Time and Attendance Coding database (17 replies)
  108. TransferDatabase acLink (4 replies)
  109. Normalizing...Get the concept just having a tough time putting i (5 replies)
  110. Category Tables: Do I HAVE to use a FK, can't I just use text? ( (13 replies)
  111. Many Cust have Many Orders (16 replies)
  112. Sectors and their Sub-Sectors related to an Officer/s...ouch! (11 replies)
  113. Inspection Database (4 replies)
  114. 3nf from the perspective of a Rookie going to far? (16 replies)
  115. Review for Normalization (22 replies)
  116. Getting a relationship to be one to many?? (16 replies)
  117. Seeking any design/structure advice. (14 replies)
  118. Should I store a field or recompute it? (9 replies)
  119. Make the default value the value last inputted (11 replies)
  120. can't create the "one-to-many"relationship and enforce referenci (13 replies)
  121. Limited duplicate entry (6 replies)
  122. is this a good structure for tables? (6 replies)
  123. Lost Primary Key (14 replies)
  124. ALTER table adds column as data type memo instead of text (7 replies)
  125. Complex Query Problem (18 replies)
  126. Normalizing my Huge table (10 replies)
  127. TransferSpreadsheet Method and AutoNumber field (3 replies)
  128. automatically generate non autonumber primary key (4 replies)
  129. remove page break symbol in .txt import (7 replies)
  130. Quick Input Mask question (4 replies)
  131. Relationship between customers in database design (9 replies)
  132. Generate Own Primary Key (8 replies)
  133. automatic update of fields in a table (12 replies)
  134. Advice on design and relationships (10 replies)
  135. Storing and sorting by month/year (5 replies)
  136. normalization problem..help! (7 replies)
  137. Update / append / or merge tables (3 replies)
  138. More questions about tables/relationships (3 replies)
  139. Linking tables (6 replies)
  140. Change Data type (11 replies)
  141. SQL in table (6 replies)
  142. How can I create a normalized employee database? (8 replies)
  143. Table design a mess! (9 replies)
  144. Reset Table AutoNumber (8 replies)
  145. table normalization (11 replies)
  146. Date as primary key (5 replies)
  147. Does it need to be this complex? (10 replies)
  148. AutoNumber default placeholders (11 replies)
  149. reservation database (3 replies)
  150. Merge data from two tables (1 reply)
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.