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, 129, 130, 131, 132
  1. For each record in tbl1 ensure at least one record in tbl2 (3 replies)
  2. removing the older data for the new ones (2 replies)
  3. many to many query (4 replies)
  4. Report structure/ table design question (18 replies)
  5. Combining data from two tables into one new (7 replies)
  6. Capabilities under FE/BE design (3 replies)
  7. Can't create a many to one relationship (12 replies)
  8. Auto Populate a Field (11 replies)
  9. Update Table with additional information to existing records (5 replies)
  10. Help! With relationship diagram (8 replies)
  11. Lookup value from a different table (4 replies)
  12. Deleting duplicate records (1 reply)
  13. editing record using dao (4 replies)
  14. Setting Default value at table level programatically (6 replies)
  15. Too many old records in my table (6 replies)
  16. Machine Activty Log Table design issues (9 replies)
  17. Cant find Database Window (7 replies)
  18. vba to update field with same name as source table (9 replies)
  19. Adding to lookup list (2 replies)
  20. Problem with lookup wizard (16 replies)
  21. Multiple orders HELP (10 replies)
  22. more than one contacts for each record (6 replies)
  23. Storing information from one table to another... (13 replies)
  24. Many to Many? (4 replies)
  25. validating table (3 replies)
  26. Importing data as new Column only (2 replies)
  27. Lookup field not showing all records (3 replies)
  28. Going back to basics (2 replies)
  29. Survey Broken into many tables (14 replies)
  30. Using a blank date as criterion in query (7 replies)
  31. Linking tables to excel....? (6 replies)
  32. You know you had a bad day when you inherit this...... (2 replies)
  33. Follow on from previous trhead (22 replies)
  34. Resetting DMax number to 0 at end of year (10 replies)
  35. My First DB sob sob HELP ! (9 replies)
  36. Do my tables look ok? (6 replies)
  37. Problem importing Excel data into Access (5 replies)
  38. Too many tables? (41 replies)
  39. Combining Fields. (2 replies)
  40. Table Design Problems (13 replies)
  41. Referential Integrity error (10 replies)
  42. Can Someone build this database for me!!! (1 reply)
  43. Linking multiple tables to a single list/combo box (4 replies)
  44. Part Quantity split by 3 colours (5 replies)
  45. Contact Infomation (1 reply)
  46. Multi User Database (10 replies)
  47. Hyperlinks in Table records (1 reply)
  48. Viewing Table/Forms & Report Connections? (1 reply)
  49. Problem updating table (2 replies)
  50. Inserting Hyperlink to many records (2 replies)
  51. Create a hyperlink in a Table (7 replies)
  52. adding up values in table (27 replies)
  53. ODBC - Read Only (3 replies)
  54. Adding a new table (1 reply)
  55. Lookup Tables Vs. Lookup Fields in Tables? (11 replies)
  56. Structure Opinion Request :) (5 replies)
  57. updating table from a calculated field in a report (4 replies)
  58. Moving data from 8 tables, into 1 Master (4 replies)
  59. Linking two tables together for a form (relationship?) (3 replies)
  60. Table structure (8 replies)
  61. the use of the aposthrophe in a key field (5 replies)
  62. Asynchronous Table Access (7 replies)
  63. autonumber field alternative (9 replies)
  64. Not all table fields show in datasheet mode (1 reply)
  65. Jury questions (8 replies)
  66. Primary key error (3 replies)
  67. link to sql server tables at host provider for my site (5 replies)
  68. Error pasting from Excel to Access (2 replies)
  69. know enough about junction tables to be dangerous (12 replies)
  70. How to delete table in code? (10 replies)
  71. cOMPARING TABLES (4 replies)
  72. Tables not linked anymore... (13 replies)
  73. In One Table, Not in Another/ joined by Common Field / Access 20 (3 replies)
  74. Linking Tables together (5 replies)
  75. arg, head hurts ... convoluted join (4 replies)
  76. Joining two tables (9 replies)
  77. Access Tables (8 replies)
  78. Append query to update a table? (1 reply)
  79. Linking Multiple Tables through VB Code /SQL (4 replies)
  80. Storing Table name as a value in the table while linking/importi (6 replies)
  81. Import and Normalisation (2 replies)
  82. Inventory Database Question (1 reply)
  83. Unhiding tables (Or anything else for that matter) (3 replies)
  84. creating new tables - noob question (1 reply)
  85. Lookup to address - looks up city as well (4 replies)
  86. Importing Excel Data in Access (3 replies)
  87. Scanning a Barcode into Access 2003 (4 replies)
  88. History (3 replies)
  89. Adding a foreign key to a subform (1 reply)
  90. Building database to track files (2 replies)
  91. Append list to one field (1 reply)
  92. Relationships for mailing labels (6 replies)
  93. Multiple Addresses in two different tables (30 replies)
  94. Tiny problem with a table (3 replies)
  95. making large tables run faster (7 replies)
  96. Saving history data when new data is entered. (8 replies)
  97. Alumni Database - Any Ideas? (4 replies)
  98. Perform a calculation on table... (6 replies)
  99. Database Replication (1 reply)
  100. AutoNumber Random Question (4 replies)
  101. Attach a document (2 replies)
  102. Having a little trouble with ccess, Need assistance if possible (11 replies)
  103. Inventory Table... (1 reply)
  104. Print Field Descriptions (2 replies)
  105. Noob relationship question! (16 replies)
  106. Modify Text Data (5 replies)
  107. AutoFill Field (1 reply)
  108. Getting stuck with new db (5 replies)
  109. First DB (22 replies)
  110. Where are my relationships? (19 replies)
  111. Updating messy database tables (3 replies)
  112. Relationships (3 replies)
  113. 82517 max records in database window, huh? (5 replies)
  114. Repeated group... how to solve this? (5 replies)
  115. Problem with reattach tables code (11 replies)
  116. Need comments in my data scheme (18 replies)
  117. Query Two Tables (3 replies)
  118. First Access DB - Do my tables look ok? (24 replies)
  119. Golf Course Table Structure (14 replies)
  120. Linked Approach dbf showing ½ character as ╜ (2 replies)
  121. Proper Data Type for Contacts Table (23 replies)
  122. Next Available Number (4 replies)
  123. MS Project type task structure (3 replies)
  124. deleting selected records (6 replies)
  125. Need Table Help (63 replies)
  126. Populate with linked data (1 reply)
  127. Major AutoNumber problem (9 replies)
  128. Importing from Excell problem (blank records appearing) (5 replies)
  129. Am I Saving Space? (3 replies)
  130. Combine Survey results into 1 table (1 reply)
  131. Correct way to Relate Tables (4 replies)
  132. Thoughts on Spec Table layout(s) (4 replies)
  133. Universal field name changes (6 replies)
  134. How do I calculate an average cost in a table (11 replies)
  135. Need some table help... (26 replies)
  136. updating / deleting records from a table (9 replies)
  137. Multiple Choice Quiz DB (4 replies)
  138. Combining Fields For Duplicate Records (1 reply)
  139. Euro Formatting at table level (5 replies)
  140. Trouble with Default Value (16 replies)
  141. how can I relate a table to another table - twice? (3 replies)
  142. I am wondering if I linked my tables correctly... (16 replies)
  143. Date range joins (5 replies)
  144. How to display data from another table in a table based on crite (2 replies)
  145. Table Structure (2 replies)
  146. Auto populate Form with single field entry...Access Beginner (2 replies)
  147. project tracking (3 replies)
  148. Commandment 2 - Justification (9 replies)
  149. Updating tables using forms based on multiple Many to Many relat (5 replies)
  150. Automatic capital for first letter in a Surname field (15 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.