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. Creating a solid foundation (correct tables, fields, relationshi (1 reply)
  2. Autonumber function for 8 digit ID# starting with 00000000? (2 replies)
  3. Hard line feed in a stored text field (6 replies)
  4. SQL Statement to Create Field of Type LOOKUP (3 replies)
  5. Downloadable Examples of a Normalized Database (3 replies)
  6. "the search key was not found in any record" error (2 replies)
  7. Multiple fields of one table using one other table for lookup (7 replies)
  8. Problem with making a query (3 replies)
  9. code for form button to open second form and enter data (1 reply)
  10. how do i reset the primary key, which is an auto number (3 replies)
  11. Linked tables (7 replies)
  12. 1 table from 2 forms (30 replies)
  13. Sorting survey questions by order asked - different for each rec (1 reply)
  14. Many to many relationship (5 replies)
  15. Address Types (3 replies)
  16. Turn table definitin into CREATE TABLE sql statement (1 reply)
  17. finding default value based on zip code input (3 replies)
  18. Linked Tables (1 reply)
  19. Renaming Table Names (8 replies)
  20. Matching Two Tables to update Data (9 replies)
  21. Class schedule tables (5 replies)
  22. Relationship Question Performance Evals (9 replies)
  23. removing blank records (5 replies)
  24. How do I use a local table in a pass through query (6 replies)
  25. Locking a Single Table (5 replies)
  26. Linking One Document to Many Others (8 replies)
  27. Request info from user in pass through query (1 reply)
  28. Set Table & Query as Hidden in VB (1 reply)
  29. updating a records field using dlookup (4 replies)
  30. Multiple access instances on the same computer (3 replies)
  31. crash db with only 1 table, 1 record, 2 fields and a subdatashee (3 replies)
  32. Opening table in VBA shows no records (1 reply)
  33. I am unable to add an index to an index collection (3 replies)
  34. Access and Hidden Tables (3 replies)
  35. Active Directory (3 replies)
  36. table subdatasheets set to none are not holding (3 replies)
  37. Linking table Date fields by month (6 replies)
  38. How can I record attendee's at numerous meetings (4 replies)
  39. Linking Excel table - Relative path (1 reply)
  40. Setting up Tables & Relationships (6 replies)
  41. Question about sub-table relationships / database design (1 reply)
  42. Display height of person in one field (11 replies)
  43. Table gets deleted in back-end (9 replies)
  44. Data Normalization - Repeating Groups (2 replies)
  45. Linking tables with the same fields (4 replies)
  46. Table Structure Advise (4 replies)
  47. Relationships puzzle (4 replies)
  48. Record Limit (1 reply)
  49. Link Tables (4 replies)
  50. Normalizing a mega table to correct tables. (8 replies)
  51. Pass through queries (3 replies)
  52. Where do relationships reside? (3 replies)
  53. Import File (10 replies)
  54. Automate "Link Table" using code (1 reply)
  55. Changing sort on table, adding autonumber (3 replies)
  56. Multivalue fields (2 replies)
  57. Relationships between 2 tables (9 replies)
  58. Relationship Structure - Insight Requested (22 replies)
  59. One Table w/Two Primary Keys Linked 4x to a Table w/Single Prim (11 replies)
  60. Survey Questions Design (2 replies)
  61. Basic question (relationships) (1 reply)
  62. How to create relationships (5 replies)
  63. Validation rule for a currency field (4 replies)
  64. Inherited a non-normalized database..... (4 replies)
  65. Consolidate fields which only appear in original table (2 replies)
  66. use createfield on linked table (1 reply)
  67. Something is just not quite right (7 replies)
  68. Accessing data in large tables (5 replies)
  69. Data Normalization Quesiton (6 replies)
  70. Change Employee Name to Primary Key (10 replies)
  71. Writing data to tables using DAO (5 replies)
  72. Referencing a recordset field name using a variable (2 replies)
  73. layout (1 reply)
  74. Advice on hoiw to set up a table and/or relationship (5 replies)
  75. Datatypes (3 replies)
  76. Altering Field Precision with VBA (3 replies)
  77. Tracking database changes (11 replies)
  78. Is there a way to create hidden table? (11 replies)
  79. Validation rule for a date field (3 replies)
  80. Linking 2 separate databases (4 replies)
  81. Access Tables and ODBC Links (10 replies)
  82. Auto Update (Tables and forms) (90 replies)
  83. Am I Normalized? (11 replies)
  84. Form with 3 sub forms - not giving the expected results (4 replies)
  85. Linked MySQL View Into Access Issue (7 replies)
  86. Multi-purpose form (5 replies)
  87. password protect a table (3 replies)
  88. Access Database; How big is too big? (12 replies)
  89. Completely Normal? :-) Question about 3NF. (22 replies)
  90. Gotta Design a Large Personnel DB...Help! (2 replies)
  91. Categories of Categories (12 replies)
  92. System fields converting to non-system fields (12 replies)
  93. Linked table problems (9 replies)
  94. Check if table exists through SQL (2 replies)
  95. Many to Many or not... (3 replies)
  96. Multiple entrites in one row to multiple rows. (6 replies)
  97. Creating Relationship between Stock Transactions and Cash dealin (12 replies)
  98. Programmatically Change name of Field (4 replies)
  99. allow duplicate data under certain conditions? (4 replies)
  100. Creating a table on the fly in a multi user environment (3 replies)
  101. Table Normalization Review (2 replies)
  102. Foreign Key Problems (6 replies)
  103. Table and relationship problem (12 replies)
  104. Linking tables (3 replies)
  105. Table and record locking (4 replies)
  106. Index Allowing Duplicates because of Listbox (5 replies)
  107. File with too many fields (8 replies)
  108. Advisor minutes (2 replies)
  109. Flat File Requires Junction Table (5 replies)
  110. Tables & Relationships Q (3 replies)
  111. Table Design for Phone Numbers (10 replies)
  112. Input mask for Phone Num and Ext. (7 replies)
  113. Table in use in Access, can't delete (5 replies)
  114. Purchasing Design Concept... Allocation by Product Category Via (1 reply)
  115. Question about relationships in BE and FE (2 replies)
  116. Table structure (1 reply)
  117. Tables with ? (5 replies)
  118. Hyperlink Editing Issue (3 replies)
  119. question about relationships (10 replies)
  120. Normalizing a table (2 replies)
  121. I'm just not seeing it... (5 replies)
  122. Refreshing table data (6 replies)
  123. Plz Help (5 replies)
  124. Capabilities Regarding sharing tables (4 replies)
  125. Conditional Data (12 replies)
  126. Too many fields defined (3 replies)
  127. Table relationship problem... (2 replies)
  128. Disconnect a linked table (3 replies)
  129. Correct Table Design (1 reply)
  130. Error msg. - cannot change record b/c related record required (7 replies)
  131. Only one person can open a split db at a time (2 replies)
  132. Subscript Out of Range Error on Import (1 reply)
  133. Linking tables (3 replies)
  134. Approval Process (1 reply)
  135. Validation rule for letters only text (3 replies)
  136. Having a number increment by one in a table (7 replies)
  137. Table design (6 replies)
  138. Managing Database (1 reply)
  139. Faster join on linked tables? (3 replies)
  140. Dtat type 'double' not big enough (7 replies)
  141. 5 rows into 1 (6 replies)
  142. Dublicate Data (1 reply)
  143. Open dialog only after Table is Closed (10 replies)
  144. Simple Inventory question (4 replies)
  145. Accounts System - Audit trail (needs speeding up!) (4 replies)
  146. Problem that has me stumped. (6 replies)
  147. Baseball Database Relationships (13 replies)
  148. relation ship (2 replies)
  149. using Access to pull informatioin from monster monthly greenbar (1 reply)
  150. Appending selected combo entry to separate table (6 replies)
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.