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. Cannot Edit Existing Record in Subform with SQL Backend (2 replies)
  2. New Record in a 2nd sub table (5 replies)
  3. Little help for first table set and relationships (3 replies)
  4. Converting MDB to a SQL database and using ASPX (8 replies)
  5. Multi field relationships (6 replies)
  6. simple quick question, single or multiple trransaction tables? (1 reply)
  7. How to set up sequential numbering? (11 replies)
  8. Calculating costs for a Treatment (9 replies)
  9. Export table/query (7 replies)
  10. Setting Up Relationships (24 replies)
  11. varying amounts of input (9 replies)
  12. Setting linked tables subdatasheet to Non (3 replies)
  13. one to many (5 replies)
  14. Relational database questions (9 replies)
  15. Limiting the Number of Record that can be produced (8 replies)
  16. Record the record ID I just added (2 replies)
  17. Invalid field definition (7 replies)
  18. Table Design: Inventory received & used (3 replies)
  19. School Assignment - Data Type Problem (3 replies)
  20. Numer Field problems (6 replies)
  21. A Questions About Reports (8 replies)
  22. autofill date (2 replies)
  23. Need to create indexes (5 replies)
  24. Bill of materials (9 replies)
  25. Getting data from a linked table (9 replies)
  26. Linked Tables not showing up in ‘Linked Table Manager’ (8 replies)
  27. Table Normalization (4 replies)
  28. Obtaining fields in a table (1 reply)
  29. importing table from another DB (5 replies)
  30. deleting/managing table references (3 replies)
  31. Is it safe to create an index? (2 replies)
  32. Fill a field depending on a value in another (4 replies)
  33. Access database - how to autopulate a table by selecting a custo (1 reply)
  34. Database Design for survey with changing questions (5 replies)
  35. Normalization of 6 tables (6 replies)
  36. New Database (2 replies)
  37. Primay Key (5 replies)
  38. Trying to create one-to-many, access forces one-to-one (3 replies)
  39. History keeping / rollback (4 replies)
  40. Auto-populate field in a table from a form (1 reply)
  41. CopyObject (3 replies)
  42. Importing into a table when columns have changed names (1 reply)
  43. Importing to Access from locked Excel file (5 replies)
  44. Updateing a linked table (7 replies)
  45. Trying to adapt the "Time and Billing" template, need guidance. (3 replies)
  46. Abbreviation to full spelling throughout form (2 replies)
  47. Relational tables and using queries for a form (3 replies)
  48. Standard Name-Addr-Ph-Fax-Email Table? (6 replies)
  49. table lookup columns based on relational tables (13 replies)
  50. Supervisor employee relationship (33 replies)
  51. Importing to Access from locked Excel file (13 replies)
  52. Type mismatch on database call (5 replies)
  53. Importing and Saving a Table (2 replies)
  54. Relationships (2 replies)
  55. PK's and FK's (5 replies)
  56. 4 records are dropping from new related table - not sure why (3 replies)
  57. View special characters? (1 reply)
  58. Ingesting data from one table to another (1 reply)
  59. Pet surgery relationships problem (3 replies)
  60. Looking for best method of table / relationship structure for sm (5 replies)
  61. This is a simple operation, why can't I see it? (14 replies)
  62. locating missing numbers in table (3 replies)
  63. Forms and Subforms relationships (1 reply)
  64. Creating a solid foundation (correct tables, fields, relationshi (1 reply)
  65. Autonumber function for 8 digit ID# starting with 00000000? (2 replies)
  66. Hard line feed in a stored text field (6 replies)
  67. SQL Statement to Create Field of Type LOOKUP (3 replies)
  68. Downloadable Examples of a Normalized Database (3 replies)
  69. "the search key was not found in any record" error (2 replies)
  70. Multiple fields of one table using one other table for lookup (7 replies)
  71. Problem with making a query (3 replies)
  72. code for form button to open second form and enter data (1 reply)
  73. how do i reset the primary key, which is an auto number (3 replies)
  74. Linked tables (7 replies)
  75. 1 table from 2 forms (30 replies)
  76. Sorting survey questions by order asked - different for each rec (1 reply)
  77. Many to many relationship (5 replies)
  78. Address Types (3 replies)
  79. Turn table definitin into CREATE TABLE sql statement (1 reply)
  80. finding default value based on zip code input (3 replies)
  81. Linked Tables (1 reply)
  82. Renaming Table Names (8 replies)
  83. Matching Two Tables to update Data (9 replies)
  84. Class schedule tables (5 replies)
  85. Relationship Question Performance Evals (9 replies)
  86. removing blank records (5 replies)
  87. How do I use a local table in a pass through query (6 replies)
  88. Locking a Single Table (5 replies)
  89. Linking One Document to Many Others (8 replies)
  90. Request info from user in pass through query (1 reply)
  91. Set Table & Query as Hidden in VB (1 reply)
  92. updating a records field using dlookup (4 replies)
  93. Multiple access instances on the same computer (3 replies)
  94. crash db with only 1 table, 1 record, 2 fields and a subdatashee (3 replies)
  95. Opening table in VBA shows no records (1 reply)
  96. I am unable to add an index to an index collection (3 replies)
  97. Access and Hidden Tables (3 replies)
  98. Active Directory (3 replies)
  99. table subdatasheets set to none are not holding (3 replies)
  100. Linking table Date fields by month (6 replies)
  101. How can I record attendee's at numerous meetings (4 replies)
  102. Linking Excel table - Relative path (1 reply)
  103. Setting up Tables & Relationships (6 replies)
  104. Question about sub-table relationships / database design (1 reply)
  105. Display height of person in one field (11 replies)
  106. Table gets deleted in back-end (9 replies)
  107. Data Normalization - Repeating Groups (2 replies)
  108. Linking tables with the same fields (4 replies)
  109. Table Structure Advise (4 replies)
  110. Relationships puzzle (4 replies)
  111. Record Limit (1 reply)
  112. Link Tables (4 replies)
  113. Normalizing a mega table to correct tables. (8 replies)
  114. Pass through queries (3 replies)
  115. Where do relationships reside? (3 replies)
  116. Import File (10 replies)
  117. Automate "Link Table" using code (1 reply)
  118. Changing sort on table, adding autonumber (3 replies)
  119. Multivalue fields (2 replies)
  120. Relationships between 2 tables (9 replies)
  121. Relationship Structure - Insight Requested (22 replies)
  122. One Table w/Two Primary Keys Linked 4x to a Table w/Single Prim (11 replies)
  123. Survey Questions Design (2 replies)
  124. Basic question (relationships) (1 reply)
  125. How to create relationships (5 replies)
  126. Validation rule for a currency field (4 replies)
  127. Inherited a non-normalized database..... (4 replies)
  128. Consolidate fields which only appear in original table (2 replies)
  129. use createfield on linked table (1 reply)
  130. Something is just not quite right (7 replies)
  131. Accessing data in large tables (5 replies)
  132. Data Normalization Quesiton (6 replies)
  133. Change Employee Name to Primary Key (10 replies)
  134. Writing data to tables using DAO (5 replies)
  135. Referencing a recordset field name using a variable (2 replies)
  136. layout (1 reply)
  137. Advice on hoiw to set up a table and/or relationship (5 replies)
  138. Datatypes (3 replies)
  139. Altering Field Precision with VBA (3 replies)
  140. Tracking database changes (11 replies)
  141. Is there a way to create hidden table? (11 replies)
  142. Validation rule for a date field (3 replies)
  143. Linking 2 separate databases (4 replies)
  144. Access Tables and ODBC Links (10 replies)
  145. Auto Update (Tables and forms) (90 replies)
  146. Am I Normalized? (11 replies)
  147. Form with 3 sub forms - not giving the expected results (4 replies)
  148. Linked MySQL View Into Access Issue (7 replies)
  149. Multi-purpose form (5 replies)
  150. password protect a table (3 replies)
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.