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. One field linked to multiple fields (4 replies)
  2. How many fields on a table? (3 replies)
  3. Design question (5 replies)
  4. Database Splitting dilemma (52 replies)
  5. Table sturctue for changing values. (1 reply)
  6. adding value of fields together (5 replies)
  7. Is this better? (21 replies)
  8. Create Field YesNo DataType and Display Control (CheckBox) (5 replies)
  9. Create custom field in table (9 replies)
  10. Tracking historical data possible in Access? (1 reply)
  11. A bit rusty I guess (11 replies)
  12. Error trap when backend is 'missing' (6 replies)
  13. Normalization (5 replies)
  14. enforce referential integrity (2 replies)
  15. Unable to change a field size-Table linked (8 replies)
  16. Avoiding duplicated addresse (4 replies)
  17. drop down list relationships. (2 replies)
  18. Importing data and creating relationships (1 reply)
  19. Attempt at normalizing dbs (16 replies)
  20. Use two tables to create one form (3 replies)
  21. Updating Table in Front End (2 replies)
  22. Proper Table Setup Question (4 replies)
  23. Relationships (11 replies)
  24. Help setting up tables.... (4 replies)
  25. Can you display / enter ft and lbs? (8 replies)
  26. Default Field Values (2 replies)
  27. INSERT (1 reply)
  28. Proper relationships set? (9 replies)
  29. Address type problem (30 replies)
  30. sharing db with .odbc links? (7 replies)
  31. Checkboxes (3 replies)
  32. Normal Forms in Access tables (3 replies)
  33. Create an Index for a Varible Named Table (5 replies)
  34. Importing data (4 replies)
  35. Link tables (3 replies)
  36. field Case format (3 replies)
  37. Ordering DB Primary Key Issue (10 replies)
  38. Decimals in tables (5 replies)
  39. Table colors (1 reply)
  40. Is this the best way or can you show me the best (5 replies)
  41. primary vs. foreign keys (7 replies)
  42. Auto ID as a Primary Key (5 replies)
  43. Question on proper database design. (1 reply)
  44. Ci3 Database Files (5 replies)
  45. making a relationship (20 replies)
  46. Structure of tables/relationships (1 reply)
  47. Gym Workout Database (3 replies)
  48. Multiple contacts in one record (retrieving data from related ta (3 replies)
  49. Making a relationship (6 replies)
  50. Mutliple Many-To-Many's... another way? (1 reply)
  51. Fields playing games with my head here LOL HELP! (5 replies)
  52. Carriage Return in a Field of a Table (3 replies)
  53. Automate addition of predetermined milestones (5 replies)
  54. Currency data type (2 replies)
  55. What would keep me from setting a one to many (12 replies)
  56. Am I setting up my tables correctly? (3 replies)
  57. form view (3 replies)
  58. Table structure (1 reply)
  59. Having trouble figuring out my setup (33 replies)
  60. New to Access, can someone check my tables/relationships? (5 replies)
  61. Linking Tables (5 replies)
  62. How is my Tables and Relationship looking? (15 replies)
  63. Creating table relationships based upon partial employee names (1 reply)
  64. Structure Advice required (9 replies)
  65. Custom Auto Number (4 replies)
  66. Excel as backend (4 replies)
  67. Address Relationship not working (14 replies)
  68. Changing the table that a form is based upon (3 replies)
  69. Multiple Users Accessing the Database (7 replies)
  70. Primary key (3 replies)
  71. Memo field gets cut down to 504 chars and prints symbols after (5 replies)
  72. Simple import is not so simple (2 replies)
  73. Are my tables Normalized? (17 replies)
  74. Switch Caption/Field Name View (3 replies)
  75. Critique Requested for New Database (3 replies)
  76. beginner question on relationships (2 replies)
  77. Existing Table Has Duplicate Keys - Can I Repair? (3 replies)
  78. Invoice and InvoiceDetails tables with relationships. (1 reply)
  79. Find blank and replace with 0 (2 replies)
  80. Foreign Key rules (1 reply)
  81. Same Field two tables (1 reply)
  82. Pivot Table based on two tables or a query? (9 replies)
  83. what data type is 0.01%? (6 replies)
  84. Relationships Error (3 replies)
  85. Records Help! (14 replies)
  86. ODBC insert on a linked table xxxx failed (2 replies)
  87. Easiest way to add 100 rows to table (1 reply)
  88. Carrying on information (1 reply)
  89. Linking to added tables (6 replies)
  90. Convert existing table to all caps (9 replies)
  91. tables for a payroll (3 replies)
  92. Create a lookup on a table (5 replies)
  93. Help needed in a plan (10 replies)
  94. Table in Back End (3 replies)
  95. Pictures, OLE in a table or not? (3 replies)
  96. Adding to linked tables (auto numbers) (2 replies)
  97. Transferring Data from one DB to Another (3 replies)
  98. Relationship error message (2 replies)
  99. Table design (3 replies)
  100. Items table and Item Movements Linked By ID not by name!!!!!!! (1 reply)
  101. Difficulty understanding recursive relationship (8 replies)
  102. Why no decimal values show (6 replies)
  103. Correcting Referential Integrity (2 replies)
  104. Can't Link to Tables in an Open DB (1 reply)
  105. Unable to relate tables (3 replies)
  106. Best way to link heriarchy of tables with missing pieces (11 replies)
  107. Avoiding Lookup Tables (7 replies)
  108. Primary Key (5 replies)
  109. lookup field dependent on other field (2 replies)
  110. Missing relationship somewhere... (2 replies)
  111. Relationships (5 replies)
  112. ODBC Links using File DSNs (3 replies)
  113. Modifying Link\Files of Types options (3 replies)
  114. Data Type - Cannot Change (4 replies)
  115. Northwind db- table relationships (4 replies)
  116. FE/BE Best Practices for Network Share (20 replies)
  117. from comma deilited to fixed‐length. (12 replies)
  118. Building a database for gage assignments (4 replies)
  119. Index called ~~temp~index~name0 (1 reply)
  120. AutoNumbering question (7 replies)
  121. Need some help with my new database (6 replies)
  122. Multilanguage Database (1 reply)
  123. New feature in 2007? (2 replies)
  124. suppressing error messages (1 reply)
  125. Entering Ranges into a Table (3 replies)
  126. How to get =b1+b2 (3 replies)
  127. two fields - first is lookup (1 reply)
  128. Room Booking Database (5 replies)
  129. Importing/Linking Tables - Size limit? (5 replies)
  130. Adding a table to a split database (4 replies)
  131. Problem with relationships in a basic database (I imported data (4 replies)
  132. Import into existing table? (4 replies)
  133. Done right? (35 replies)
  134. Where is the TextFormat property? (7 replies)
  135. text field (1 reply)
  136. The best approach? Booking Events and Venues System (4 replies)
  137. Combining Tables (6 replies)
  138. Duplicated Primary Keys Problem (13 replies)
  139. Table structure opinions (3 replies)
  140. 255 Field Limit: is there a way around it? (5 replies)
  141. ResetAutonumber (8 replies)
  142. populating field values (6 replies)
  143. Appending tables (8 replies)
  144. define field width (2 replies)
  145. Call logging DB, relationship problem probably. (5 replies)
  146. Insert Into Table ERROR (4 replies)
  147. Many table not filling out (23 replies)
  148. Review of Tables and Relationships (6 replies)
  149. Related or unrelated data in two tables (3 replies)
  150. Category Conundrum (27 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.