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. MM relationship (5 replies)
  2. Can it be done if so how? (7 replies)
  3. Table Design (9 replies)
  4. Function in Table not Query (4 replies)
  5. Identifying duplicate records (2 replies)
  6. Rate-my-normalisation! (3 replies)
  7. Table relationship (many to many?) (1 reply)
  8. Vailidity check of 2 fields in same table from 1 form (3 replies)
  9. Removing data from table. (2 replies)
  10. Need Suggestions on Attendance System (4 replies)
  11. Simple table relationships - is there a definitive answer? (9 replies)
  12. How to store the historical data (4 replies)
  13. Foreign Key Help Again (1 reply)
  14. natural PK Vs autonumber PK debate (31 replies)
  15. Customer Comments DB again :( (3 replies)
  16. Canonical Key Definition (2 replies)
  17. "Could not find linked table" (1 reply)
  18. Key Help (5 replies)
  19. DoCmd Transferdatabase creates Db with Hidden Tables (3 replies)
  20. Lookup from a different table (3 replies)
  21. Use two forms to make one db structure (10 replies)
  22. Merge 2 identical databases (2 replies)
  23. Corrupt DB ... Requires Compact and Repair (10 replies)
  24. storing and formatting a look-up field in the table (1 reply)
  25. How can I insert /'s into a string of numbers? (5 replies)
  26. updating info that have Lookup fields in tables (7 replies)
  27. Import Boolean data issue (5 replies)
  28. Linking to Relativity Issues (1 reply)
  29. dates that training completed for employees (4 replies)
  30. Tables (1 reply)
  31. Autonumber and Foreign Key Problems (1 reply)
  32. Switch from linked table to imported table? (4 replies)
  33. Calculated Fields (4 replies)
  34. SQL vs ADO Recordset (3 replies)
  35. Why can't I format an individual cell in a table? (3 replies)
  36. Ordering a table by more than one field? (4 replies)
  37. Questionnaire Data Structure (6 replies)
  38. maximum DB size (8 replies)
  39. field size (3 replies)
  40. Automated Import (2 replies)
  41. Normalisation for a newbie (6 replies)
  42. Form data not be updated in underlying table (1 reply)
  43. import a spreadsheet on a command button (1 reply)
  44. Combining data from two fields into one (5 replies)
  45. Table design questions (6 replies)
  46. Normalize this ! This should be a surprising and interesting t (30 replies)
  47. Cant Link A Table From Access DB (1 reply)
  48. Validation - 0 to 10,000. (3 replies)
  49. Drop down boxes (7 replies)
  50. Autonumber with an input mask! is it possible? (2 replies)
  51. Compare excel workbooks and pull certain info into one of them (1 reply)
  52. Referential Integrity (38 replies)
  53. Look ups in main table or Form? (Normalisation) (5 replies)
  54. Query results into a table (1 reply)
  55. Converting Excel Workbook to Access DB (19 replies)
  56. Link to tables on server (1 reply)
  57. New Record Automatically Created (2 replies)
  58. Can't get the first record in a table. (3 replies)
  59. Adding a formula to a table (9 replies)
  60. Table with a Formula (4 replies)
  61. New ID_Record insert inbetween rows (12 replies)
  62. Advice on New Database Creation (4 replies)
  63. Are my tables normalised and the relationships correct? (2 replies)
  64. 255 field limit in a table (16 replies)
  65. Table Setup for Handhelds and Blackberry's (1 reply)
  66. Attempting to normalize database I've been working on... (16 replies)
  67. Record Navigation (1 reply)
  68. Stuck on synchronizing forms (6 replies)
  69. Multiplying values within a table - possible? (5 replies)
  70. Seperating Data from One Field to Multiple Fields (3 replies)
  71. Stop rounding my percentages! (3 replies)
  72. Field Type and validation rule (6 replies)
  73. Filter available results in field "b" by what was entered in fie (3 replies)
  74. Many to Many relationships (2 replies)
  75. Delete all tables except 1! (3 replies)
  76. Access Table To DB3 Format (1 reply)
  77. Referential Integrity (6 replies)
  78. Renaming Tables already in use (4 replies)
  79. Rename, Import data from list of dbf files (2 replies)
  80. Relating for reporting (1 reply)
  81. Retrieving data in a form from tables (5 replies)
  82. Relationship Issues (3 replies)
  83. Date Validation - Modified Following Business Day (7 replies)
  84. Prevent duplicates based on multiple criteria (23 replies)
  85. Import tables from multiple db's within a directory (10 replies)
  86. Normalising this database - the Saga (1 reply)
  87. Access 2.0 (6 replies)
  88. Help/Advice on table structure please (3 replies)
  89. Customer comments database (screen inside) (6 replies)
  90. Autonumber Not Matching It's Index! (4 replies)
  91. Lookup of a Price with Min and Max Qty (3 replies)
  92. Controlling record saving (8 replies)
  93. Stock Quantity Query (1 reply)
  94. Simple product loan database (6 replies)
  95. FIND ERROR WHEN IMPORT DATA FROM XLS (3 replies)
  96. Change data type with VB... (5 replies)
  97. Sub table not creating "entry Id" in main table (4 replies)
  98. CORRUPT BACKEND (8 replies)
  99. Listing Tables (7 replies)
  100. Compare two tables (28 replies)
  101. Q- Changing multiple fields (2 replies)
  102. Too many Memo Fields? (6 replies)
  103. Automatically add field to a table. (2 replies)
  104. strange entries in a table.. (5 replies)
  105. Recording History - stuck on table design (9 replies)
  106. suggestion on table design (1 reply)
  107. Normalisation - Is it to 3NF (25 replies)
  108. Simple Relationship/Join Problem I Can't seem to figure out (3 replies)
  109. after re-naming tables, forms no longer work (4 replies)
  110. Help a beginner with errors...Please (3 replies)
  111. Multiple fields relating to single record in another table (1 reply)
  112. Unique Indexes. (7 replies)
  113. Double data entry (3 replies)
  114. How can I increase Field Size to more than 255 bytes? (1 reply)
  115. Applying ‘test’ database changes to the ‘live’ database (12 replies)
  116. Import Help (11 replies)
  117. Copying Import Specs (2 replies)
  118. Departments with agencies, creating relationships (6 replies)
  119. Paste Append (5 replies)
  120. Random populating a schedule (2 replies)
  121. table within a table? (3 replies)
  122. Newbie Access question regarding tables (5 replies)
  123. Figured Out How to unhide tables (2 replies)
  124. Copying columns or fields from one database to another (2 replies)
  125. Hidden Table (2 replies)
  126. Which are the keys within my table? (1 reply)
  127. Complicated Import Problem (3 replies)
  128. Displaying just the desired results in Combo box (6 replies)
  129. linking content field of one table with another (3 replies)
  130. Join 2 tables in form (15 replies)
  131. Limiting number of duplicate values for a field (3 replies)
  132. Store result of query into table (5 replies)
  133. Help with Price File (5 replies)
  134. Stopping new entry (8 replies)
  135. relationship issues (1 reply)
  136. joining 3 tables (2 replies)
  137. Help with Access 2003 Table Structure (3 replies)
  138. Really noobish, but how to lock a table (1 reply)
  139. Newbie Table Normalization question (2 replies)
  140. ERROR DELETING RECORD FROM TABLE (1 reply)
  141. Importing corresponding fields from records in one table to anot (1 reply)
  142. Accessing Multiple Tables in a Single Form (3 replies)
  143. How to split a database into frontend and backend (2 replies)
  144. date() problem more .... (4 replies)
  145. Get multiple values in field (1 reply)
  146. "#Deleted" in all fields for one record in the table cannot be r (1 reply)
  147. Excel spreadsheet instead of access tables? (1 reply)
  148. Table setup for lookup (5 replies)
  149. TROUBLE WITH "WHERE" CLAUSE (8 replies)
  150. Changing Linked table pathname in VBA (2 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.