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
  1. 'Numeric Field Overflow' error on text file import (15 replies)
  2. Locked Table (6 replies)
  3. VBA command to access field names from open table (10 replies)
  4. Are self referencing relationships a Bad Thing? (3 replies)
  5. Defaulting new record information from existing record (10 replies)
  6. OLE Objects (19 replies)
  7. Synchronize drawings (8 replies)
  8. db structure. (18 replies)
  9. With The Help Of Everybody I'm Making Progress!!!! (19 replies)
  10. Quote Generator (2 replies)
  11. Autonumber (9 replies)
  12. DB2 ODBC Driver (4 replies)
  13. How do i normalize this? (12 replies)
  14. Newbie needing to do an employee time card program (2 replies)
  15. Table Structure for appointments (6 replies)
  16. So many problems with design that my head hurts!! (18 replies)
  17. Implementing User-defined Fields - New Table? (14 replies)
  18. Church Membership Database (7 replies)
  19. Database Structure (14 replies)
  20. Writing conflict on SQL Server linked table (5 replies)
  21. SQLexe statement to add AutoIncrement ID as key to a table (7 replies)
  22. Change Linked Table Path By Code (8 replies)
  23. Using a junction table (28 replies)
  24. Relationships logic (15 replies)
  25. Very Ugly Data (25 replies)
  26. Quote DB; Help with design and layout (10 replies)
  27. Database Design (27 replies)
  28. How to determine when back-end file has been updated (6 replies)
  29. Re-designing a db - Please critique (7 replies)
  30. Combo Boxes - Primary key & text for form use (13 replies)
  31. Database Documenter question (5 replies)
  32. Create an automatic text PK (11 replies)
  33. I'm new to access and its sending me mad! (9 replies)
  34. 1.01 = 1.00 ... What the? (8 replies)
  35. timesheet model / methodology (3 replies)
  36. Junction Table not working (8 replies)
  37. Project Management Relationship/Tables... (3 replies)
  38. loading a memo field from an external source (13 replies)
  39. Right align currency field (11 replies)
  40. create a primary key in an existing table that currently does no (4 replies)
  41. Yes / No fields and number fileds (13 replies)
  42. Lookup Value (6 replies)
  43. Unlocking a locked linked table (3 replies)
  44. Lookup table, or Relationship?? (28 replies)
  45. Input Masks (4 replies)
  46. Creating a hyperlink field in a module (7 replies)
  47. Autonumber corruption and table recreation (7 replies)
  48. From Concept to Practice (11 replies)
  49. foreign key (8 replies)
  50. composite keys - to foreign keys (10 replies)
  51. error- property value is too large (3 replies)
  52. Linking with Code (7 replies)
  53. Linked Table: Possible to make it read only? (4 replies)
  54. Another relationship suffers from my inexperience (17 replies)
  55. New User needing help with 1st time design of sales/commission d (10 replies)
  56. Normalized structure and data entry... (11 replies)
  57. primary key must be numerical? (27 replies)
  58. Problem with table design for Tree of Diagnosis (16 replies)
  59. Relationships and Normalization Help, Please. (9 replies)
  60. Time and Attendance Coding database (17 replies)
  61. TransferDatabase acLink (4 replies)
  62. Normalizing...Get the concept just having a tough time putting i (5 replies)
  63. Category Tables: Do I HAVE to use a FK, can't I just use text? ( (13 replies)
  64. Many Cust have Many Orders (16 replies)
  65. Sectors and their Sub-Sectors related to an Officer/s...ouch! (11 replies)
  66. Inspection Database (4 replies)
  67. 3nf from the perspective of a Rookie going to far? (16 replies)
  68. Review for Normalization (22 replies)
  69. Getting a relationship to be one to many?? (16 replies)
  70. Seeking any design/structure advice. (14 replies)
  71. Should I store a field or recompute it? (9 replies)
  72. Make the default value the value last inputted (11 replies)
  73. can't create the "one-to-many"relationship and enforce referenci (13 replies)
  74. Limited duplicate entry (6 replies)
  75. is this a good structure for tables? (6 replies)
  76. Lost Primary Key (14 replies)
  77. ALTER table adds column as data type memo instead of text (7 replies)
  78. Complex Query Problem (18 replies)
  79. Normalizing my Huge table (10 replies)
  80. TransferSpreadsheet Method and AutoNumber field (3 replies)
  81. automatically generate non autonumber primary key (4 replies)
  82. remove page break symbol in .txt import (7 replies)
  83. Quick Input Mask question (4 replies)
  84. Relationship between customers in database design (9 replies)
  85. Generate Own Primary Key (8 replies)
  86. automatic update of fields in a table (12 replies)
  87. Advice on design and relationships (10 replies)
  88. Storing and sorting by month/year (5 replies)
  89. normalization problem..help! (7 replies)
  90. Update / append / or merge tables (3 replies)
  91. More questions about tables/relationships (3 replies)
  92. Linking tables (6 replies)
  93. Change Data type (11 replies)
  94. SQL in table (6 replies)
  95. How can I create a normalized employee database? (8 replies)
  96. Table design a mess! (9 replies)
  97. Reset Table AutoNumber (8 replies)
  98. table normalization (11 replies)
  99. Date as primary key (5 replies)
  100. Does it need to be this complex? (10 replies)
  101. AutoNumber default placeholders (11 replies)
  102. reservation database (3 replies)
  103. Merge data from two tables (1 reply)
  104. No Unique Index when Creating Table Relationship (3 replies)
  105. Beginner question: how many PKs per table? (7 replies)
  106. Queries (11 replies)
  107. Indexes in Access databases (10 replies)
  108. A different survey database question (19 replies)
  109. How to get "CREATE..." DDL statements for existing tables (6 replies)
  110. Rename Table using VBA - with user input (13 replies)
  111. Table set-up (12 replies)
  112. .mdt file? (4 replies)
  113. FK's; required versus Null values (26 replies)
  114. HELP...Hope this is the right place (24 replies)
  115. Automatic date update (14 replies)
  116. Erase/Filter out spaces in records (10 replies)
  117. Single vs Double numeric data type (8 replies)
  118. Tables or Queries (11 replies)
  119. Composite Keys possible? (21 replies)
  120. Combine first and last name (4 replies)
  121. How to prevent duplication of 2 fields in records (12 replies)
  122. Question about table Structure in Pedigree DB (27 replies)
  123. Autonumbers and Indexing Issues (6 replies)
  124. Accounting Journal - how to do double entry? (9 replies)
  125. Providing totals in a table (10 replies)
  126. Help with attached db (18 replies)
  127. Convert number to Autonumber (3 replies)
  128. Dealing with Spaghetti in the Relationships Window (9 replies)
  129. Database Design/Normalization (10 replies)
  130. Table Stucture and Relationships (14 replies)
  131. Table Stucture and Relationships help (12 replies)
  132. Random Confirmation Numbers (24 replies)
  133. Questionnaire Theory (14 replies)
  134. Create Linked tables in current directory (7 replies)
  135. Would this be better in Access or Excel? (9 replies)
  136. Creating a database with many-to-many relationships (21 replies)
  137. AutoNumber - recycle values (5 replies)
  138. Help with deleting duplicate Records (12 replies)
  139. Using Autonumber field as a primary key (10 replies)
  140. Data Modelling question (10 replies)
  141. Lost Linked Tables (10 replies)
  142. Normalization dilemma (12 replies)
  143. Related Tables (7 replies)
  144. Alter table & date format (2 replies)
  145. How would you create a circulating database? (11 replies)
  146. Total newb Q on table structure (32 replies)
  147. link table to external site, eg ftp site? (4 replies)
  148. why am I having such a hard time with this.. normalization probl (8 replies)
  149. Help needed with table design (12 replies)
  150. Library system help (14 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.