Full Version: Access Tables + Relationships
UtterAccess 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
  1. What is BCNF (5 replies)
  2. Input Mask of a date format (9 replies)
  3. Importing a spaced delimited unfixed width text file via vba (24 replies)
  4. TransferSpreadsheet Import Errors (5 replies)
  5. Need advice on table relationship (13 replies)
  6. How to read normalized records (10 replies)
  7. Tracking subscriptions for Journals and Issues (10 replies)
  8. Comparing Data (23 replies)
  9. missing table since upgrade to access 2003 or 2007 (6 replies)
  10. Relationships not visible (5 replies)
  11. Problems formatting a number as a percent (15 replies)
  12. many to many linking to proper fields (11 replies)
  13. Table question (28 replies)
  14. Validation Rule For Field (7 replies)
  15. add record wth left join (4 replies)
  16. Deleting table data not the actual table structure (11 replies)
  17. A little Bit of Interesting Experience with "SubDataSheets" (10 replies)
  18. Tables linked via DNS Connection (3 replies)
  19. Removing comaas, spaces, slahes, parenthesis, and dashes from fi (9 replies)
  20. Table Lost Primary Key (5 replies)
  21. order by number using text field (5 replies)
  22. Not sure what I'm looking for?... (11 replies)
  23. Structure question around 1 to 1 relationships (9 replies)
  24. Advice on Storing Historical Data per Job (13 replies)
  25. General structure question (10 replies)
  26. Determine in code if a table field has an AutoNumber Data Type (21 replies)
  27. Design Help (8 replies)
  28. Currency is rounding to the nearest dollar! (6 replies)
  29. Database Normalization (15 replies)
  30. Do relationships still need to be set when using autonumber as k (7 replies)
  31. copy values from old record to new one (8 replies)
  32. Expression Builder question (3 replies)
  33. Pass Table parameter to function / sub procedure. (21 replies)
  34. Importing data from Excel (11 replies)
  35. Lost in the Relationship Sauce (10 replies)
  36. Age validation rule (1 reply)
  37. one table multiple relationships (7 replies)
  38. A Scout Camp Database - defining the tables (6 replies)
  39. Link Table Manager (15 replies)
  40. Database Design question (16 replies)
  41. Quoting Database Table's help (6 replies)
  42. Many to many relationships (13 replies)
  43. linking many to many relationship with bridge table (5 replies)
  44. Table is getting too big (3 replies)
  45. passing fields from one table to another (12 replies)
  46. Dealing with data changes (6 replies)
  47. Open OLE object from Table (9 replies)
  48. Design of Tables?! (7 replies)
  49. Code solution needed (11 replies)
  50. concatenating multiple fileds from multiple records (horizontall (14 replies)
  51. Creating a database that mimics a Recipe book (2 replies)
  52. Help needed with addresses (6 replies)
  53. Pros and cons of Linking vs Importing (12 replies)
  54. If You Can Help Plz (7 replies)
  55. Questionnaire Database Design - Questions Table (4 replies)
  56. OLE Object in table (7 replies)
  57. Average a set of scores (8 replies)
  58. Gym booking database (3 replies)
  59. Tables disappearing off left side of Relationships (9 replies)
  60. Prevent Saving Data (automatically) in a Table from a Form (3 replies)
  61. Comments on DB - don't be gentle!!! (10 replies)
  62. Database design suggestions (12 replies)
  63. AutoNumber (16 replies)
  64. relationships (5 replies)
  65. Help with time-dependent database design (14 replies)
  66. Row Level Tracking; necessary or not? (4 replies)
  67. Many types of People in People table? (7 replies)
  68. IP Address Validation Rule (3 replies)
  69. Daily Log Database - Date / Time Question (1 reply)
  70. Check constraint (5 replies)
  71. Record Locking (10 replies)
  72. Check box to numbers (9 replies)
  73. Request for normalization critique (10 replies)
  74. Evils of Access - Part 2 (13 replies)
  75. Normalization and Planning (14 replies)
  76. entering city with , (16 replies)
  77. Adding a Field to a Table (12 replies)
  78. Trouble adding new records (8 replies)
  79. A table of formulas ? (5 replies)
  80. In short, What do table relationships accomplish? (9 replies)
  81. Revising tables in a split database (10 replies)
  82. Advanced Relationships (22 replies)
  83. Recursive Relationships (7 replies)
  84. Financial statement database (1 reply)
  85. Design Question, booleans (11 replies)
  86. Changing Linked Tables properties (6 replies)
  87. Virtual Table to A Table (3 replies)
  88. Normalize confusion (9 replies)
  89. Zipcode table (11 replies)
  90. Importing a DBF file (3 replies)
  91. How to link FE/BE tables via VBA? :) (14 replies)
  92. Table Drop Downs (9 replies)
  93. Structure help (9 replies)
  94. Relating tables/forms to pass the same ID for each district (11 replies)
  95. deleting table links problem (4 replies)
  96. Date problem (8 replies)
  97. use table instead of select case? (20 replies)
  98. reset autonumber (6 replies)
  99. on delete cascade (5 replies)
  100. Sub-table: default record code (7 replies)
  101. How can I set up a relationship between one column and two diffe (14 replies)
  102. linked table manager (11 replies)
  103. are my tables normalized? (8 replies)
  104. Unknown function "Environ".... (9 replies)
  105. NVL from PL/SQL to a MS ACCESS 2002 or MS ACCESS - SQL (2 replies)
  106. tables/primary keys/forms (14 replies)
  107. Can't delete field because of old relationship (3 replies)
  108. Cascade Update/Delete -- Pros/Cons ? (1 reply)
  109. Table Structure (24 replies)
  110. Normalization Question (6 replies)
  111. Contacts table (5 replies)
  112. Error - database engine could not lock table! (10 replies)
  113. Create Table DDL with CASCADE DELETE (7 replies)
  114. Command to edit a record in a table (10 replies)
  115. Combo vs Option group (5 replies)
  116. Encrypt a Table (5 replies)
  117. Relationship Build between tables (9 replies)
  118. MsysObjects Table: Date updated question (2 replies)
  119. Phone Number Input Mask (10 replies)
  120. Concatenate text from tables (18 replies)
  121. Recombine/Remerge Split DB (4 replies)
  122. Can you link to a table held in a .mdb on the internet ? (4 replies)
  123. Employees and wages (5 replies)
  124. DoCmd.CopyObject table Linked to Local help! (8 replies)
  125. Relationship between to diffrent fields? (10 replies)
  126. Single or multiple tables (10 replies)
  127. Filling text boxes with data after user selects from combo box (14 replies)
  128. Get the field type of a primary key field (9 replies)
  129. Make a copy of a table in backend using VBA (4 replies)
  130. Relationships problem (36 replies)
  131. Can't force Text datatype in linked Excel table! (5 replies)
  132. Homegrown synchronization of table data (4 replies)
  133. Find the primary key of a table using DAO (6 replies)
  134. relationship not possible (5 replies)
  135. Regarding Lookup Fields in Tables (5 replies)
  136. Created a Column named "Money" (8 replies)
  137. Question revolving around "inventory" DB design (22 replies)
  138. Reversing a one-to-many relationship (13 replies)
  139. Employee table --> 2 fields in Project Table (5 replies)
  140. Custom Record Navagation Buttons and Text Box (5 replies)
  141. Combine two fields in a table to auto fill another field in same (4 replies)
  142. help with table design (38 replies)
  143. Table linked to a item on a field (18 replies)
  144. Client ID (autonumber or not) (6 replies)
  145. Design Table Question (14 replies)
  146. Access Tables... (10 replies)
  147. How to create an ODBC link for Access (6 replies)
  148. Delete field though VBA (14 replies)
  149. Image Database (5 replies)
  150. ToDoList database design (26 replies)
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.