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. Export, Import and update records in a table (5 replies)
  2. turn arrays into table (2 replies)
  3. form and table not linking (1 reply)
  4. Align Numbers Left (4 replies)
  5. Preserving values in a table (4 replies)
  6. Consignment (1 reply)
  7. Relationships disppearing (3 replies)
  8. #Num! in some fields when linking Excel spreadsheet (1 reply)
  9. Setting up Relationships (6 replies)
  10. Changing Field Size (2 replies)
  11. Importing vs Linking (1 reply)
  12. ZIP, CITY, STATE (11 replies)
  13. Linking Batch Purchases to individual Sales (FIFO) (8 replies)
  14. Indexed - No Duplicates (6 replies)
  15. access simple problem but can be confusing.. (1 reply)
  16. CRM System Design/Manipulation (1 reply)
  17. default value question (1 reply)
  18. Importing Autonumbers (3 replies)
  19. What fields should/not be included in a junction table? (3 replies)
  20. Autonumber reset upon change of year (6 replies)
  21. Drawing Data from Multiple Tables (6 replies)
  22. Design Question (7 replies)
  23. One-to-many relationship on linked tables (1 reply)
  24. Relationship for real estate agency (3 replies)
  25. Finding common elements in tables (4 replies)
  26. get a (-) as standard value (5 replies)
  27. Export to Excel: Lookup Fields Only Send ID, Not Value (7 replies)
  28. Importing Errors from Exel Table (1 reply)
  29. Combo boxes field types (4 replies)
  30. help with new tables for a fashion matrix of size x colour x qua (9 replies)
  31. Problem with linked ODBC tables (2 replies)
  32. Automatic field fill-in (2 replies)
  33. Purchase orders database setup (10 replies)
  34. Pick autonumber start (8 replies)
  35. Microsft Jet Database and Linked Tables (6 replies)
  36. attempting to change the same data at the same time. (5 replies)
  37. How to update multiple form records by making change to one tabl (1 reply)
  38. Indexing Issue? (6 replies)
  39. Join on different field types (6 replies)
  40. Choosing a PK (15 replies)
  41. User access & password structure (1 reply)
  42. Entry in a field in a parent automatically going into a filed in (12 replies)
  43. Variable Lookup Box (1 reply)
  44. How the Foreign Key Actually gets its Data from the Primary Key (5 replies)
  45. Add fields after table contains info (4 replies)
  46. Quick question about an asterisk (15 replies)
  47. protecting a linked table (3 replies)
  48. hindsight 2020 (2 replies)
  49. Automatic Record Creation (3 replies)
  50. Primary Key generated by a formula in Access 2007 (7 replies)
  51. Contacts and addresses (1 reply)
  52. Setting up relationship and normalization (3 replies)
  53. Limiting the possible selections based on previous fields (4 replies)
  54. Going from 2NF to 3NF? (4 replies)
  55. Setting multiple fields to PK - faster indexing? (6 replies)
  56. Table field / Relation advise (4 replies)
  57. Importing email with attachments (2 replies)
  58. Confusing Relationships (16 replies)
  59. Relations & Qry issues (1 reply)
  60. Store Old Index (3 replies)
  61. Linked tables' registries showing as #DELETED (3 replies)
  62. Relationship message (3 replies)
  63. Split DB's & Lookup Tables (3 replies)
  64. OLE object field for formatted text (1 reply)
  65. Undercover Formatting (5 replies)
  66. Help for school project (29 replies)
  67. Relationship Troubles (9 replies)
  68. Inventory Table (3 replies)
  69. Autonumber Limit? (9 replies)
  70. I dont know what this is called (1 reply)
  71. RELATIONSHIPS (I think) (2 replies)
  72. Navigating tables with the '+' sign to the left of the records. (4 replies)
  73. converting a Julian Date (7 replies)
  74. Indexing & Unique Fields of table (3 replies)
  75. Normalization question (5 replies)
  76. Data from one table to another (1 reply)
  77. Maximum Field Length (2 replies)
  78. Strange "table open" error when its not... (6 replies)
  79. "locked" table - not updating data (9 replies)
  80. Corrupt primary key (1 reply)
  81. Would like some advice (3 replies)
  82. multiple left outer joins on the same table (1 reply)
  83. Folder link from field (1 reply)
  84. Table Relationships in Datasheet View (1 reply)
  85. Standard practices. (7 replies)
  86. Relationships (1 reply)
  87. Combining Tables/forms (1 reply)
  88. Importing table information stored as backup (10 replies)
  89. Stuck with database structure (30 replies)
  90. Is there a way to generate a report of a table layout? (3 replies)
  91. secure a table (20 replies)
  92. making fields automitically udate based on info from another tab (1 reply)
  93. Autonumber formatting (14 replies)
  94. Virtually no Static Information - A Table Design Question (4 replies)
  95. Help-- Tables-Filter (3 replies)
  96. Showing which rooms available and which are not (small hotel dat (1 reply)
  97. find tables in Access 2007? (5 replies)
  98. Creating PK from Imported Data (3 replies)
  99. Table Normalizing or what ... (3 replies)
  100. Working With Duplicates (2 replies)
  101. Table relationships query (1 reply)
  102. Something simple I can't seem to do!!! (6 replies)
  103. Set Primary Key on import (1 reply)
  104. converting "current" data to "previous" data (3 replies)
  105. Normalization from flat tables keeping existing data (4 replies)
  106. Move record from table to table (9 replies)
  107. Servicing database ... adding missed visits (12 replies)
  108. Link Tables (5 replies)
  109. Case Sensitive Key Fields (3 replies)
  110. automaticaly add record in related table (5 replies)
  111. Delete un populated records (5 replies)
  112. Do I need 1 Jct or Multiple Normal tables? (4 replies)
  113. tracking vehicle systems - database structure (13 replies)
  114. change link to point to a different table in the same database (2 replies)
  115. A Little Guidance (2 replies)
  116. Shuffle Records? (9 replies)
  117. autonumber stopped working (6 replies)
  118. Edit Linked Table Source (2 replies)
  119. link a frontend to a linked table on the backend (7 replies)
  120. Importing Multiple Date fields (2 replies)
  121. A T&R setup connundrum! (5 replies)
  122. Fieldnames of table collected from email in Outlook (1 reply)
  123. data entry (1 reply)
  124. Number of FKs (30 replies)
  125. Importing data from a Word table (1 reply)
  126. Help with my Structure *DELETED* (3 replies)
  127. How to replace backend's table without losing the data and integ (3 replies)
  128. referential integrity problem (4 replies)
  129. Removing blank records #2 (3 replies)
  130. Annual table "Clean up" (11 replies)
  131. Project Management Tables (12 replies)
  132. Names, Phones, Phone Types (7 replies)
  133. can't enforce referential integrity (2 replies)
  134. Advice needed for project (2 replies)
  135. Quantities relationship design advice (9 replies)
  136. ODBC Connection to link tables (4 replies)
  137. flat file into relational database (1 reply)
  138. Add table to split database (4 replies)
  139. Tables and searching in an access db (1 reply)
  140. List boxes & Bin Ranges (6 replies)
  141. Find And Replace Charater In Whole Table Druing Runtime (8 replies)
  142. Filter & ServerFilter (7 replies)
  143. Data type Currency, custom format (2 replies)
  144. Field Size (1 reply)
  145. What is BCNF (5 replies)
  146. I have photos (8 replies)
  147. Combine Data from Multiple Columns into One Column (2 replies)
  148. Input Mask of a date format (9 replies)
  149. Copying Tables in a Macro (3 replies)
  150. Table field for ~1000 characters (1 reply)
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.