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. Month & Year (2 replies)
  2. Simple Schools Directory Database (5 replies)
  3. outlook linked table problem (0 replies)
  4. Is this 'normalized'? (2 replies)
  5. using access for a bank of medical questions (2 replies)
  6. Normalization and Duplicative Data (2 replies)
  7. Remedial Question (5 replies)
  8. Potential one-to-one relationship? (13 replies)
  9. Deleting/Changing results in 'Value you entered isnt valid for this field' (2 replies)
  10. Relationships Between Tables (2 replies)
  11. When you lock a master row does it lock related child records (1 reply)
  12. Backspace clears text field (4 replies)
  13. import of data from excel (4 replies)
  14. Tables & many to many relationships (57 replies)
  15. the Correct Relationship (14 replies)
  16. The Correct Relationship Revisited (2 replies)
  17. One to Many Table (5 replies)
  18. Creating Form From Relationship Table (3 replies)
  19. Linking data from a master sheet (1 reply)
  20. Question about # of locks in Multi-user app (0 replies)
  21. Validating table field based on query value (1 reply)
  22. Can't Create One-To-One Relationship (12 replies)
  23. Linked table relationships (5 replies)
  24. Lab Sample Storage Database (4 replies)
  25. Table structures (2 replies)
  26. Database of PDF documents? (14 replies)
  27. Converting date formats (3 replies)
  28. Table not updateable in Access 2007 (3 replies)
  29. Question regarding FK. (3 replies)
  30. Rolling 30 Days Add in -1 Point (2 replies)
  31. error message: cannot add record because a related record is needed (13 replies)
  32. linked tables (5 replies)
  33. Multi-User Question (13 replies)
  34. Is it OK to use data as PK in this instance? (7 replies)
  35. Setting up a master/child relationship? (2 replies)
  36. Am I going right in table design and relationship !? Where am I ? (3 replies)
  37. formatting date (4 replies)
  38. Insert A Number Such as 0.15 (1 reply)
  39. AutoNumber (6 replies)
  40. Many-to-Many Relationship with three tables (9 replies)
  41. Junction table off a junction table? (5 replies)
  42. Basic Table Design (21 replies)
  43. Input Mask (6 replies)
  44. combine telephone number with extension (2 replies)
  45. Can autonumber be linked to another field? (6 replies)
  46. Import spec for ODBC visual foxpro table (5 replies)
  47. Importing, Relationships, and Joining problems (1 reply)
  48. Linking two tables (15 replies)
  49. Importing into a database with prior relationships (2 replies)
  50. To-do list database planning question (8 replies)
  51. Combining two tables with respect to each unique record's individual data cells (1 reply)
  52. Collapsing fields (1 reply)
  53. Can't set Cascading Delete (17 replies)
  54. linked tables (1 reply)
  55. Duplicates in a table (7 replies)
  56. Create a defined number of records using a field in a table (2 replies)
  57. 1 vs Multiple Tables (6 replies)
  58. Error Message (1 reply)
  59. relationship question (14 replies)
  60. Null value error (3 replies)
  61. What is a lookup table and why are they used. (5 replies)
  62. basic inventory system (7 replies)
  63. converting primary keys (15 replies)
  64. Equivalent key combo (1 reply)
  65. Tables & Relationships for a name that can keep changing (7 replies)
  66. Need Advice in Designing Database Relationships (9 replies)
  67. table and relatinships (8 replies)
  68. Updating a field after table s updated (6 replies)
  69. Composite Keys and Table Relationships (8 replies)
  70. relationship: one table related to two tables on the same field (3 replies)
  71. Local table and Linked table to SQL 2008 (5 replies)
  72. Creating new data in linked table (6 replies)
  73. Relationship problem (5 replies)
  74. duplicate detection on multiple fields (18 replies)
  75. Resource Planning Tool - Backend (9 replies)
  76. Creating a custom Autonumber field (4 replies)
  77. Why is access asking me to enter a value in a field that doesn't exist (7 replies)
  78. table/relationship question (2 replies)
  79. I want my update to a table to overwrite nonduplicate primary key (3 replies)
  80. Quick design question for machine and employee database (2 replies)
  81. Some upsized (to SQL Server) table relationships did not transfer (4 replies)
  82. Populate 1 field in table with DateDiff function from 2 other fields? (3 replies)
  83. "Allow multiple values" for a lookup field (4 replies)
  84. Linking Tables (6 replies)
  85. One to many relationships (1 reply)
  86. I need to split an Access record into multiple records. (2 replies)
  87. Using an Db Template (4 replies)
  88. Possible complications from converting field from text/255 to memo format? (5 replies)
  89. Amateur Questions (Lists) (1 reply)
  90. Object Descriptions (13 replies)
  91. Trim a length of Characters (3 replies)
  92. How to relate join 2 fileds from a table to 1 field in another (9 replies)
  93. Assigning costs to resources to calculate price (21 replies)
  94. Help with updating a table (1 reply)
  95. the search key was not found in any record (3 replies)
  96. Multiple Mailing Addresses and Shared Addresses (9 replies)
  97. Benefits of Referential Integrity? (4 replies)
  98. DROP DOWN LIST: ONLY GOODS OF SPECIFIC SUPPLIER (9 replies)
  99. Can someone tell me if I did this right? (2 replies)
  100. Diminishing Inventory? How? (10 replies)
  101. Structure for multiple lookup options (1 reply)
  102. Validation rule or... (5 replies)
  103. Help I am Stuck - With Creating Forms and Relationships (3 replies)
  104. How can I merge/append similar data from different tables? (9 replies)
  105. Designing a competitor Database (16 replies)
  106. referencing across two tables (3 replies)
  107. Mailing Address and Street Address for Realtor (1 reply)
  108. Need a different approach (to the same problem) (3 replies)
  109. Relationship for tracking movement of Inventory (6 replies)
  110. Linking one table with many fields in another table (4 replies)
  111. Access Help for Coursework (2 replies)
  112. Linking Text Files (5 replies)
  113. Referring to another field of the same table (2 replies)
  114. linked table filenames mixed up (1 reply)
  115. Temporary table or not (7 replies)
  116. Lending library Loan table (4 replies)
  117. Adding a table to existing db. (4 replies)
  118. Normalized or Lookup (8 replies)
  119. Junction table maintenance (3 replies)
  120. Relationship Help (4 replies)
  121. Normalization rules (5 replies)
  122. Cannot Update Recordset (23 replies)
  123. Import Field Limits From Excel (4 replies)
  124. Converting non-normalized data into normalized data (followup to duanecwilson's questi (4 replies)
  125. Multi-Value Lookup Field problem (5 replies)
  126. Importing Excel files into normalized database (9 replies)
  127. Data is '#Deleted'? (4 replies)
  128. Synchronize files (3 replies)
  129. concatenating values in default value (2 replies)
  130. lookup tables (1 reply)
  131. Please suggest on table design (7 replies)
  132. Importing data into linked tables - VERY slow (3 replies)
  133. Table structure options (6 replies)
  134. Linked Tables Issue (3 replies)
  135. Table concern (1 reply)
  136. record appears to delete, but wont delete from table with delete record button from wi (8 replies)
  137. Primary Key field name same as foreign key (10 replies)
  138. How to apply 'invoice #' to transactional data (0 replies)
  139. Importing information from one table to another (3 replies)
  140. Expand pointer and subsets (1 reply)
  141. Location Lookup (14 replies)
  142. Auto delete in Table?? (1 reply)
  143. Creating a Unique Invoice Number (4 replies)
  144. Temp Table (6 replies)
  145. Need to create a table/report which will be an audit of all users who are logging into (3 replies)
  146. New Record Default Based on Another Table (1 reply)
  147. Fields to store from lookups (6 replies)
  148. Do I put this in the Header or Detail Table ? (4 replies)
  149. Managing new stocks. (3 replies)
  150. Is chart of accounts a recursive relationship? (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.