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. table and relatinships (8 replies)
  2. Updating a field after table s updated (6 replies)
  3. Composite Keys and Table Relationships (8 replies)
  4. relationship: one table related to two tables on the same field (3 replies)
  5. Local table and Linked table to SQL 2008 (5 replies)
  6. Creating new data in linked table (6 replies)
  7. Relationship problem (5 replies)
  8. duplicate detection on multiple fields (18 replies)
  9. Resource Planning Tool - Backend (9 replies)
  10. Creating a custom Autonumber field (4 replies)
  11. Why is access asking me to enter a value in a field that doesn't exist (7 replies)
  12. table/relationship question (2 replies)
  13. I want my update to a table to overwrite nonduplicate primary key (3 replies)
  14. Quick design question for machine and employee database (2 replies)
  15. Some upsized (to SQL Server) table relationships did not transfer (4 replies)
  16. Populate 1 field in table with DateDiff function from 2 other fields? (3 replies)
  17. "Allow multiple values" for a lookup field (4 replies)
  18. Linking Tables (6 replies)
  19. One to many relationships (1 reply)
  20. I need to split an Access record into multiple records. (2 replies)
  21. Using an Db Template (4 replies)
  22. Possible complications from converting field from text/255 to memo format? (5 replies)
  23. Amateur Questions (Lists) (1 reply)
  24. Object Descriptions (13 replies)
  25. Trim a length of Characters (3 replies)
  26. How to relate join 2 fileds from a table to 1 field in another (9 replies)
  27. Assigning costs to resources to calculate price (21 replies)
  28. Help with updating a table (1 reply)
  29. the search key was not found in any record (3 replies)
  30. Multiple Mailing Addresses and Shared Addresses (9 replies)
  31. Benefits of Referential Integrity? (4 replies)
  32. DROP DOWN LIST: ONLY GOODS OF SPECIFIC SUPPLIER (9 replies)
  33. Can someone tell me if I did this right? (2 replies)
  34. Diminishing Inventory? How? (10 replies)
  35. Structure for multiple lookup options (1 reply)
  36. Validation rule or... (5 replies)
  37. Help I am Stuck - With Creating Forms and Relationships (3 replies)
  38. How can I merge/append similar data from different tables? (9 replies)
  39. Designing a competitor Database (16 replies)
  40. referencing across two tables (3 replies)
  41. Mailing Address and Street Address for Realtor (1 reply)
  42. Need a different approach (to the same problem) (3 replies)
  43. Relationship for tracking movement of Inventory (6 replies)
  44. Linking one table with many fields in another table (4 replies)
  45. Access Help for Coursework (2 replies)
  46. Linking Text Files (5 replies)
  47. Referring to another field of the same table (2 replies)
  48. linked table filenames mixed up (1 reply)
  49. Temporary table or not (7 replies)
  50. Lending library Loan table (4 replies)
  51. Adding a table to existing db. (4 replies)
  52. Normalized or Lookup (8 replies)
  53. Junction table maintenance (3 replies)
  54. Relationship Help (4 replies)
  55. Normalization rules (5 replies)
  56. Cannot Update Recordset (23 replies)
  57. Import Field Limits From Excel (4 replies)
  58. Converting non-normalized data into normalized data (followup to duanecwilson's questi (4 replies)
  59. Multi-Value Lookup Field problem (5 replies)
  60. Importing Excel files into normalized database (9 replies)
  61. Data is '#Deleted'? (4 replies)
  62. Synchronize files (3 replies)
  63. concatenating values in default value (2 replies)
  64. lookup tables (1 reply)
  65. Please suggest on table design (7 replies)
  66. Importing data into linked tables - VERY slow (3 replies)
  67. Table structure options (6 replies)
  68. Linked Tables Issue (3 replies)
  69. Table concern (1 reply)
  70. record appears to delete, but wont delete from table with delete record button from wi (8 replies)
  71. Primary Key field name same as foreign key (10 replies)
  72. How to apply 'invoice #' to transactional data (0 replies)
  73. Importing information from one table to another (3 replies)
  74. Expand pointer and subsets (1 reply)
  75. Location Lookup (14 replies)
  76. Auto delete in Table?? (1 reply)
  77. Creating a Unique Invoice Number (4 replies)
  78. Temp Table (6 replies)
  79. Need to create a table/report which will be an audit of all users who are logging into (3 replies)
  80. New Record Default Based on Another Table (1 reply)
  81. Fields to store from lookups (6 replies)
  82. Do I put this in the Header or Detail Table ? (4 replies)
  83. Managing new stocks. (3 replies)
  84. Is chart of accounts a recursive relationship? (1 reply)
  85. Critique My Plan! (6 replies)
  86. Q regarding relationships (6 replies)
  87. Planning the database (4 replies)
  88. Linked Table Manager via VBA (7 replies)
  89. Number of Fields Limitation in a Table (1 reply)
  90. =Environ("username") not recognised in runtime? (3 replies)
  91. Interesting problem with indexes (9 replies)
  92. calculated field. (9 replies)
  93. Table Normalization (7 replies)
  94. Linked table manager (4 replies)
  95. Add File Creation Date as a field in table (3 replies)
  96. Linked Table Manager - refreshing links (3 replies)
  97. currency format (1 reply)
  98. Structure (5 replies)
  99. 2 tables become 1 (and I'm under the gun!) (20 replies)
  100. Table advice please (6 replies)
  101. Normalise to 'BCNF' Help/Guide (34 replies)
  102. Disappearing Data (1 reply)
  103. Employee and WorkCode Timesheet (Designing) (1 reply)
  104. difference in tables (1 reply)
  105. cannot link relationship between 5 tables (19 replies)
  106. Autopopulate values (2 replies)
  107. Query or Relationship? (6 replies)
  108. New Simple Database Ideas Please (4 replies)
  109. Sounding boards needed - Access 2007 database (2 replies)
  110. Converstion of Text to Number in Access Query (2 replies)
  111. lookup table with 2 columns (3 replies)
  112. limit table in subform to five items (4 replies)
  113. Table Structure and related help... (7 replies)
  114. Table Relationships Criteria Disabled (2 replies)
  115. Database design help (5 replies)
  116. Options in 2007 (5 replies)
  117. Quick table design question (tracking course changes) (0 replies)
  118. Relationship and Combo box filtering (1 reply)
  119. Year/Date (5 replies)
  120. A 'Required' field is no longer working (14 replies)
  121. Relationship the wrong way round (1 reply)
  122. Barcode datatype in access (4 replies)
  123. Help required for correct approach (15 replies)
  124. Primary Key Question (3 replies)
  125. Table check (36 replies)
  126. Validate Rule for Dates (4 replies)
  127. Undo split tables (5 replies)
  128. Creating an inventory database (2 replies)
  129. Modification Anomalies (6 replies)
  130. Junction Tables / Normalization - am I on the right track? (10 replies)
  131. best way to edit data in table (13 replies)
  132. can't view relationships (2 replies)
  133. pushing table updates to multiple copies of a database (1 reply)
  134. Learning SQL a benefit? (6 replies)
  135. Remove Odd Characters (18 replies)
  136. Can I create a relationship using 'Like Criteria' (2 replies)
  137. Merge table into another table (2 replies)
  138. Relationship Check (5 replies)
  139. linked table (3 replies)
  140. Many to Many relationship or One to Many (8 replies)
  141. Comparing two tables (3 replies)
  142. Upload Word document to Access (6 replies)
  143. Validation Rule (18 replies)
  144. 'Either or' relationship (8 replies)
  145. Starting with the basics of the basics (2 replies)
  146. tables + relationship + query (5 replies)
  147. use DDL to remove indexes from table (12 replies)
  148. Tables M-N (11 replies)
  149. to store or not to store.. (5 replies)
  150. need to change an autonumber field value (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.