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