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. Link Tables (tons of records) (2 replies)
  2. Duplicate Record with foreign key (2 replies)
  3. One big or many small tables (3 replies)
  4. Datasheet input in Form with Foreign Key (8 replies)
  5. Problem with relationships (10 replies)
  6. Combo Box Column List (4 replies)
  7. Multiple Keys on on History Table (3 replies)
  8. How to Join to table and create one with all data from both table? (3 replies)
  9. Reset autonumber field to new number (not 1) (4 replies)
  10. How to import Yes/No values from Excel? (2 replies)
  11. Number field (4 replies)
  12. Autonumber field not incrementing properly - reusing #'s - YIKES! (4 replies)
  13. Beginner question re data entry (6 replies)
  14. extracting the year from the date (1 reply)
  15. Converting a date text column to numbers (2 replies)
  16. Problem with date fields in linked text file (2 replies)
  17. Does Order of Fields Make Any Difference (3 replies)
  18. Autonumber Relationships (3 replies)
  19. Queries create new table records (14 replies)
  20. import from excel (3 replies)
  21. complex relationship? (2 replies)
  22. "tNotes" is a "GHOST" table...? in a lighter mood (3 replies)
  23. error when trying to delete relationship: "...no delete permissions..." (3 replies)
  24. Excel Table Link (2 replies)
  25. Many to many relationship setup (3 replies)
  26. Storing email address in data automatically received from Outlook (1 reply)
  27. Adding Additional Courses (14 replies)
  28. Code to import .xls document and keeping the headers? (1 reply)
  29. Is table relationships correct (1 reply)
  30. Combine company inventory products with customer furnished products in same list? (1 reply)
  31. Weird sorting of data in a table (2 replies)
  32. Validation Rule on Blank field (15 replies)
  33. '02 access form have field automatically generate multiple records based on previous f (2 replies)
  34. "Cannot open database" when trying to import data (3 replies)
  35. Help Needed on Proper Table/Relationship Design (1 reply)
  36. How To Merge Records With Different Data? (5 replies)
  37. merging tables and forumulas question (1 reply)
  38. Adding a field to a back end and the FE form lookup does not work (5 replies)
  39. Referential Integrity (4 replies)
  40. Employee table and Security information (1 reply)
  41. Database design - which table to assign fields to (7 replies)
  42. ERD problem, many to many question (9 replies)
  43. Cannot add multiple events for same date (7 replies)
  44. edited record (2 replies)
  45. Cannot insert a row (5 replies)
  46. Export table to file, ignoring decimals on currency and pad with 0's (4 replies)
  47. Help with relationships (3 replies)
  48. One master table or multiple tables (3 replies)
  49. Tables and Relationships (7 replies)
  50. Keeping original recordset (3 replies)
  51. front end back end question (4 replies)
  52. ODBC Connection Created But "ODBC Connection ... Failed" In Access (5 replies)
  53. tblClients linked to tblProposals and tblJobs, now they want to add new Divisions ?? (9 replies)
  54. Access 2007 Relationship problem (7 replies)
  55. Network drive disconnect problem (6 replies)
  56. Linking to Sharepoint Tables -- Multiple items in one field (3 replies)
  57. One to one relationships (7 replies)
  58. Are multiple field indexes the best performing? (5 replies)
  59. Table Search Speed (4 replies)
  60. Email Reminder (5 replies)
  61. Input Mask for Australian Mobile phone? (2 replies)
  62. nested subforms and relations (1 reply)
  63. Planning hierarchy of database (3 replies)
  64. I know very little about Access so I don't know where to put my question (5 replies)
  65. Which is the "proper" way to design this (16 replies)
  66. Effect of Indexes on file size. (4 replies)
  67. Table-Field property (1 reply)
  68. Table Fields into Text Boxes (3 replies)
  69. Single customer with many transactions (1 reply)
  70. Viewing Relationships (3 replies)
  71. Tables into SQL Server (1 reply)
  72. Autonumber (4 replies)
  73. Restructuring (10 replies)
  74. Make table 2003 to work in 2007 (7 replies)
  75. How do caps at field level? (11 replies)
  76. how to proceed from here in terms of forms and queries (1 reply)
  77. Tables with no relationship question. (6 replies)
  78. getting some basics right ( i hope) (3 replies)
  79. Adding records to a table with decimal places? (6 replies)
  80. Temp Table solution? (2 replies)
  81. Relationships with 'field names'? (9 replies)
  82. Table Relationship Help (25 replies)
  83. Table View problem (1 reply)
  84. Creating a Relationship (13 replies)
  85. Realtime value in a field (2 replies)
  86. Save a variable to be used later on (2 replies)
  87. I split my big table up to separate the MEMO. Mistake? (11 replies)
  88. My Access Auto Auction DB (4 replies)
  89. New Project Help - Relationships etc.. (4 replies)
  90. help with recrdset object -- error 3251 not updtateable (10 replies)
  91. Part Number cross reference for many situations (3 replies)
  92. Is there a different way to link tables via VBA? (5 replies)
  93. How to create a table structure that can store detail values (6 replies)
  94. Designing a Database (9 replies)
  95. Primary key decision - advice appreciated (11 replies)
  96. Relationships - No Unique Index (1 reply)
  97. New Project Help with these fields please (2 replies)
  98. single query using two databases (5 replies)
  99. Tables, Relationships, (3 replies)
  100. Item Container Help (2 replies)
  101. Converting from Access 97 to Access 2002/2003 (2 replies)
  102. Table Structure Set up (15 replies)
  103. Referencing other records from same table within that table (3 replies)
  104. Need Database Help (9 replies)
  105. Input Mask (2 replies)
  106. Type Conversiion Failure (5 replies)
  107. Updating a field based on new info (5 replies)
  108. Tables Detail (5 replies)
  109. Link MS SQL2005 server tables through ODBC (3 replies)
  110. recording staff ID (28 replies)
  111. Automatically creating records (3 replies)
  112. Sample Database if somebody could help (4 replies)
  113. Edit Relationships Dialog Check Boxes grayed out (1 reply)
  114. Data Clipboard (5 replies)
  115. Beginer question (10 replies)
  116. Access 2002 Combine Multiple Records Into One (2 replies)
  117. Getting information from one form into another...kinda. (1 reply)
  118. Primary key - maximum number of fields (16 replies)
  119. contact type issues (2 replies)
  120. Left over lock files (laccdb) (4 replies)
  121. Creating a Table with 2 entries (2 replies)
  122. Issues and ready to pull my hair out (4 replies)
  123. Normalising with multiple languages (1 reply)
  124. Normalising Venue Addresses - Request for suggestions (4 replies)
  125. Best way to link tables together? (11 replies)
  126. One to one Relationships (8 replies)
  127. Table Design: Assistance Required (2 replies)
  128. Finance stocks Tables (5 replies)
  129. Invoice/Payment tables problem (1 reply)
  130. Table structure for many-to-many project and company reference list (2 replies)
  131. How to hide tables created (4 replies)
  132. SAP to 'other' system + mapping table (7 replies)
  133. Primary Key That Can Be Null? (11 replies)
  134. Delete all records from a table (3 replies)
  135. Relationship Problems (17 replies)
  136. unifying multiple inventory types (simple i think) (5 replies)
  137. adding a column import spec (1 reply)
  138. Format a case number Example: 00-00000, I need the dash (6 replies)
  139. programmatically create dbboolean with checkbox? (3 replies)
  140. Copying tables from old BE to new BE, how to deal with referential integrity (4 replies)
  141. Modifying Linked Tables on a Backend programmatically (7 replies)
  142. Create Field from field in other table (20 replies)
  143. First day of the month in the query (3 replies)
  144. Is is possible? (4 replies)
  145. Question about normalizing/structure tables (3 replies)
  146. Many to Many relationship - stuck as 'data violates integrity rules' (13 replies)
  147. how to (3 replies)
  148. Access Estimating or Proposal (1 reply)
  149. Store history of changes (3 replies)
  150. Analysis date table design (6 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.