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. Anything wrong with multiple FKs to same table? (6 replies)
  2. Bad Record forces database to close (3 replies)
  3. Pulling a picture into a form using "Attachment" (10 replies)
  4. Move data from 3 fields in one table to 1 field in another table (2 replies)
  5. Final Year University Project (5 replies)
  6. "Joint" table? (7 replies)
  7. Correct Table Creation (6 replies)
  8. Calculated fields based on multiple records in single field (1 reply)
  9. How do I create a Form based on these relationships? (12 replies)
  10. I'm not a smart man Jenny! (9 replies)
  11. Table Auto Numbering (2 replies)
  12. How do you know if a database is corrupt? How do you fix it? (7 replies)
  13. Problems manipulating data (11 replies)
  14. Normalising of product categories (4 replies)
  15. Is Financial Year and Offcier a 1-many or one to one? (25 replies)
  16. Capturing numeric position of alphabetical list (5 replies)
  17. Normalizing existing tables (3 replies)
  18. FK failing to auto populate (7 replies)
  19. Re-linking BE (3 replies)
  20. Error message - cannot add or change record b/c related record i (3 replies)
  21. export to fixedwidth text does not work correctly (1 reply)
  22. Combo box problem (12 replies)
  23. Where did this table come from? (3 replies)
  24. Two tables - Only one recognized (14 replies)
  25. Managing Address/Contact details (6 replies)
  26. Weak Relationships and referential integrity (3 replies)
  27. Relationship Design (8 replies)
  28. Link table question (6 replies)
  29. Does it waste space not to keep field lengths short? (2 replies)
  30. Should fields be indexed? (3 replies)
  31. Table design (6 replies)
  32. Count number of Tables (4 replies)
  33. How to open detail form (2 replies)
  34. Compare Tables (3 replies)
  35. Looking for help understanding structure (13 replies)
  36. Combining tables with some fields overlapping (1 reply)
  37. many to many relationship (6 replies)
  38. Design Question (2 replies)
  39. What to include in an Asset table? (8 replies)
  40. Table Auto Rounding (9 replies)
  41. Event on Not in List creates a lookup table! (2 replies)
  42. Multiple Links (7 replies)
  43. Fantasy Football Database (4 replies)
  44. Trying to populate a table column (1 reply)
  45. Passing a text-box value to a table when control sourse is alrea (10 replies)
  46. Having trouble setting a relationship with a multi-field key (3 replies)
  47. Adding a pseudo primary key to linked tables (3 replies)
  48. Documentor doesn't show table names (2 replies)
  49. need advice on table structure/relationships (3 replies)
  50. 03 Table Design,combo box/value list unable to add to (7 replies)
  51. Compact on Close Option (2 replies)
  52. Database Structure (3 replies)
  53. Converting a single table to multi level (1 reply)
  54. Referencing first part of a postcode (7 replies)
  55. Problem After Normalization (9 replies)
  56. Linking Many Surveys To One Participant Number (2 replies)
  57. Linking Table Question! (1 reply)
  58. Access Table is not Inserting Records start with Zero (1 reply)
  59. creating tables that have a common column (9 replies)
  60. Table Relationship Help (3 replies)
  61. Only one query? (6 replies)
  62. Table linking question - Where is the link info stored? FE or BE (3 replies)
  63. Access freezes when going to a certain record (1 reply)
  64. New to Access...question about creating a contract database (15 replies)
  65. Relationship Not Working (5 replies)
  66. 2 linked tables.. 3 fields, linking with relationship (3 replies)
  67. Normalization anomoly? (2 replies)
  68. Two tables have become incompatible with program (5 replies)
  69. Junction Table Primary Key (4 replies)
  70. Specific table relationship question (8 replies)
  71. text field size (3 replies)
  72. record insert advice needed (5 replies)
  73. Edit records in query does not save to table (5 replies)
  74. One-to-One Relationship problem (6 replies)
  75. Counting number of occurrences of each value in each field (3 replies)
  76. Write Conflict (7 replies)
  77. is my relationship correct (3 replies)
  78. Primary Key (2 replies)
  79. Table/Form Design (4 replies)
  80. Table design (6 replies)
  81. Inventory Control Database / Tracking Parts (6 replies)
  82. Access 2007 & Sharepoint Lists .. (5 replies)
  83. Application - User Interface with Tables (4 replies)
  84. Database Normalisation (3 replies)
  85. Trying to design a Diary System? (1 reply)
  86. Quarterly Data (3 replies)
  87. Link Cell to a complete Table (9 replies)
  88. Doctors with many specialties (7 replies)
  89. Importing Tables/Splitting /Etc. (4 replies)
  90. Normalization dilemma (4 replies)
  91. strange frameshift corruption... or is it? (3 replies)
  92. Where do I put 'CREATE VIEW' syntax? (1 reply)
  93. Linking Tables in Separate DBs (18 replies)
  94. Structure problems. Also Junction tables anyone?? (17 replies)
  95. Sequential Numbering (6 replies)
  96. question about primary keys (13 replies)
  97. Lock table? (3 replies)
  98. One field linked to multiple fields (4 replies)
  99. How many fields on a table? (3 replies)
  100. Design question (5 replies)
  101. Database Splitting dilemma (52 replies)
  102. Table sturctue for changing values. (1 reply)
  103. adding value of fields together (5 replies)
  104. Is this better? (21 replies)
  105. Create Field YesNo DataType and Display Control (CheckBox) (5 replies)
  106. Create custom field in table (9 replies)
  107. Tracking historical data possible in Access? (1 reply)
  108. A bit rusty I guess (11 replies)
  109. Error trap when backend is 'missing' (6 replies)
  110. Normalization (5 replies)
  111. enforce referential integrity (2 replies)
  112. Unable to change a field size-Table linked (8 replies)
  113. Avoiding duplicated addresse (4 replies)
  114. drop down list relationships. (2 replies)
  115. Importing data and creating relationships (1 reply)
  116. Attempt at normalizing dbs (16 replies)
  117. Use two tables to create one form (3 replies)
  118. Updating Table in Front End (2 replies)
  119. Proper Table Setup Question (4 replies)
  120. Relationships (11 replies)
  121. Help setting up tables.... (4 replies)
  122. Can you display / enter ft and lbs? (8 replies)
  123. Default Field Values (2 replies)
  124. INSERT (1 reply)
  125. Proper relationships set? (9 replies)
  126. Address type problem (30 replies)
  127. sharing db with .odbc links? (7 replies)
  128. Checkboxes (3 replies)
  129. Normal Forms in Access tables (3 replies)
  130. Create an Index for a Varible Named Table (5 replies)
  131. Importing data (4 replies)
  132. Link tables (3 replies)
  133. field Case format (3 replies)
  134. Ordering DB Primary Key Issue (10 replies)
  135. Decimals in tables (5 replies)
  136. Table colors (1 reply)
  137. Is this the best way or can you show me the best (5 replies)
  138. primary vs. foreign keys (7 replies)
  139. Auto ID as a Primary Key (5 replies)
  140. Question on proper database design. (1 reply)
  141. Ci3 Database Files (5 replies)
  142. making a relationship (20 replies)
  143. Gym Workout Database (3 replies)
  144. Multiple contacts in one record (retrieving data from related ta (3 replies)
  145. Making a relationship (6 replies)
  146. Mutliple Many-To-Many's... another way? (1 reply)
  147. Fields playing games with my head here LOL HELP! (5 replies)
  148. Carriage Return in a Field of a Table (3 replies)
  149. Automate addition of predetermined milestones (5 replies)
  150. Currency data type (2 replies)
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.