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. Which relationship is right...if Any? (7 replies)
  2. advise needed on database design (3 replies)
  3. Front End / Back End tables (20 replies)
  4. Staff structure problem (28 replies)
  5. 2 primary keys (4 replies)
  6. Add new field to various linked tables (4 replies)
  7. finding duplicte data in 2 tables (1 reply)
  8. HR(Employees) DB (4 replies)
  9. Database Structure (6 replies)
  10. Designing a Purchase Order Database (5 replies)
  11. Oracle Tables (3 replies)
  12. String Compares (4 replies)
  13. add a month (6 replies)
  14. Storing "Images" in a separate table (12 replies)
  15. Replicate Cell Data Automatically (4 replies)
  16. Custom autonumber-ing (2 replies)
  17. Best table design? (4 replies)
  18. Non-Matching Records (2 replies)
  19. Follow-up Dates formulas (9 replies)
  20. Ordering system (4 replies)
  21. SQL ALTER TABLE (1 reply)
  22. Linked Excel Tables--Say it Ain't So! (7 replies)
  23. Linked Exchange folder - path question (0 replies)
  24. Populating a table based on the value of another table (2 replies)
  25. Linking Access to Sage Accounts (4 replies)
  26. Validate a field based on a value in another Field in the table (8 replies)
  27. Hidden Tables (2 replies)
  28. update query for specific records (4 replies)
  29. Multiple alter table statements/1 query (3 replies)
  30. Table Exist (4 replies)
  31. Database structure, junction tables and Foreign Keys (3 replies)
  32. Different tables for phisical address and bill address (1 reply)
  33. Record Selection with multiple criteria (0 replies)
  34. Control Table (3 replies)
  35. DSN-Less Connections in Access 97 (1 reply)
  36. Sequential number (10 replies)
  37. Tiering Question (3 replies)
  38. Flat Files to Main Table Question (3 replies)
  39. Tables Hidden from veiw (10 replies)
  40. Best way to tackle this design problem? Client/WorkType/SubWorkT (2 replies)
  41. update a inter number to short time format (5 replies)
  42. Connecting two fields on a form from the same table (4 replies)
  43. Accession numbers per year (1 reply)
  44. Append data failed (2 replies)
  45. How do I fill in the spaces in my reports? (2 replies)
  46. Using MS Access 2003 to export into XML (2 replies)
  47. ODBC - Connection within a Form (3 replies)
  48. Problem with Linked Tables and Updating Info (1 reply)
  49. Word to Access table (3 replies)
  50. How to build in a version checker? (3 replies)
  51. Too many indexes??!! (1 reply)
  52. importing from Excel to normalized Access db (6 replies)
  53. Auto Numbering Field (3 replies)
  54. help needed in getting the right relationships (1 reply)
  55. Link two tables for use in dropdown (2 replies)
  56. Relationship Advice (3 replies)
  57. Lock a table for updating (4 replies)
  58. Microsoft Access and Survey Development (2 replies)
  59. Northwind isn't completely Normalized (5 replies)
  60. Transfer Text (13 replies)
  61. Function like Excel : "New Web Query" (0 replies)
  62. new relationship causing problems (3 replies)
  63. Process genealogies with repassages (5 replies)
  64. ODBC relationship question (3 replies)
  65. Linked tables from SQL into Access, how to set default values (3 replies)
  66. Problem with copying and pasting table (2 replies)
  67. Validation Rule Help! (3 replies)
  68. If two columns contain same info? (duplicates) (4 replies)
  69. Missing Decimal Point in Imported Currency Data (3 replies)
  70. Having a tough time with normalizing (4 replies)
  71. Truncate based on character (6 replies)
  72. Date calculation between two inputs creates future date output. (1 reply)
  73. Checking for network connection (3 replies)
  74. Unsure about relationships (1 reply)
  75. Multiple field (Composit) Primary key...Should I? (7 replies)
  76. Finally, a project for fun...But how to design it? (1 reply)
  77. two digit year to four digit (3 replies)
  78. Relationship help! (7 replies)
  79. Importing .txt file into Access 2003 (3 replies)
  80. See if a table is locked (2 replies)
  81. QUESTION - Restarting autonumber (5 replies)
  82. Setting up database (design) (23 replies)
  83. Importing Relationships BUT not the tables (9 replies)
  84. Import Errors (1 reply)
  85. Import CSV Problem (4 replies)
  86. linked excel table not updating (3 replies)
  87. Best way for a column to house Numbers and Text? (2 replies)
  88. Simple (hopefully) question about table data (3 replies)
  89. Creating a set of tables for multiple users. (1 reply)
  90. Autonumber not able to generate the primary key I need? (3 replies)
  91. Resolving Post codes... (4 replies)
  92. Membership Database - Invoicing after 365 days (9 replies)
  93. force global uppercase (5 replies)
  94. Remove Ending Spaces (3 replies)
  95. Relationship + other problems (2 replies)
  96. How to link a Commission Payments table to sales database (1 reply)
  97. linked table not updating (0 replies)
  98. Search from Website Using Access (1 reply)
  99. Time stamp in access (1 reply)
  100. How to generate a list of system objects (3 replies)
  101. Hide Duplicate Record Warning Message (6 replies)
  102. idnetifying duplicate records in a table (3 replies)
  103. Customer With Several Locations (0 replies)
  104. Whats the diffrence/meaning of Single Double Data types (5 replies)
  105. Locked Tables (3 replies)
  106. how to store multiple records against a primary key? (11 replies)
  107. Overriding 'Required' error messages (1 reply)
  108. Room booking system (4 replies)
  109. Records Supposedly Deleted on Import? (4 replies)
  110. LINK TABLES (3 replies)
  111. keep the zero in the front (3 replies)
  112. Design View printing problem (3 replies)
  113. Update Table data without duplicates (3 replies)
  114. Linked tables not getting updated info. (4 replies)
  115. How to type in percentages in a table cloumn (2 replies)
  116. Data Base Design Question (7 replies)
  117. Changing Data Type of a Linked Table (3 replies)
  118. Information on setting up ODBC link TO an access database (2 replies)
  119. Many to Many/Junction Table (1 reply)
  120. import from .txt to access table (4 replies)
  121. Do I need a new table? (3 replies)
  122. Storing a calculated field in a table for later comparison. (3 replies)
  123. Help a newbe? (11 replies)
  124. Table Relationships (1 reply)
  125. Table Design (7 replies)
  126. Table value generated with IF THEN Construct (2 replies)
  127. Add 7 days automatically in a field in a table (3 replies)
  128. Replacing a Table (9 replies)
  129. Data Modeling Issue (2 replies)
  130. With new store as StoreId How to add StoreId to 2nd table. (3 replies)
  131. trying to link two fields in different tables (1 reply)
  132. User should not add a new record to a table (5 replies)
  133. Change AutoNumber (1 reply)
  134. Design Normalization (2 replies)
  135. Relationships in a split database (1 reply)
  136. Reivew of Table Structure (7 replies)
  137. restrict modifications (1 reply)
  138. Update UserID and TimeStamp in a table (1 reply)
  139. Auto Calculation not saving in table (3 replies)
  140. Dbase Tables (3 replies)
  141. currency field formatting question (1 reply)
  142. Forms disappeared! (4 replies)
  143. You cannot add or change a record because a related record is re (21 replies)
  144. Tables Help (6 replies)
  145. running code behind a table? (3 replies)
  146. Need suggestions for designing a table structure (1 reply)
  147. Best design for performance (13 replies)
  148. Chop of last digit of a numeric field (3 replies)
  149. AUTONUMBER (3 replies)
  150. tick box auto fills field with date? (11 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.