View Full Version : Microsoft Access Database Table Design

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

  1. appointments diary with cross-referenced timetable reports
  2. Trying to reduce number of fields
  3. Difference in size of actual access database and its backup
  4. {Q} How to modify record in M Access database?
  5. tinkering with split databases
  6. modifying backend tables and relinking
  7. Re: comparing table values
  8. Autonumber records inserted in gaps
  9. Working with question-answer pairs
  10. Simple Access Project - Almost There Just Need Some Help...
  11. time inpute mask help please
  12. Service Work Order Form
  13. Project : Retail Pharma Database
  14. Connect Tables? I have too many fields
  15. Re: Normalizing Tables
  16. table design feedback request for plating shop bath testing
  17. help with table design for Code Library
  18. Why won't Access assign a Primary Key ID to my linked SQL Table?
  19. Benefits of knowledge base software
  20. Requiring one field contingent on data in another field
  22. Select 'ONLY = TO'
  23. Table Design Question
  24. beginner : SQL in access
  25. Multiple Relationship between 2 tables
  26. Field Default Value
  27. Hospital Equipment & Maintenance Database
  28. Table design and information normalization
  29. normalizing and creating fields or related tables
  30. Table relationships between 42 tables
  31. Making new records from a subform
  32. Linking tables and autofilling fields
  33. Real Estate Contract Database Design
  34. -1 and 0 for "Yes" and "No" (?)
  35. table help
  36. CreateField Method or Data Member Not Found
  37. Re: No display of Linked Table Mgr
  38. One to one relationship
  39. How to normalize this data
  40. DoCmd.SetWarnings False
  41. A many-to-many challenge
  42. Age Validation
  43. Re: Null field when checking for duplicates in an Index
  44. Newbie problem, Added a link table for a many to many. Can't insertbecause of a foreign key constraint
  45. Limit on number of fields in MS Access forms
  46. Re: Linked Tbl Mgr behavior
  47. One Tbl? Or three?
  48. One Check box or Two
  49. Design Confusion!
  50. Auto Fill in table
  51. Autonumber associated with date
  52. How to know if # of indeces is too many?
  53. one to many design
  54. Table design for a recurring monthly charges to clients
  55. Table changes cause "the recordset is not updateable???"
  56. Cumulative values - deducting the previous value
  57. Beg. Access Class Instructor's Comment
  58. A Bit Confused
  59. How to hard code two values for a column?
  60. Help with normalization
  61. How do I make a multi-field primary key?
  62. What controls "add new field"?
  63. Number of characters in a table name
  64. ManyToManyRelationship
  65. Re: creating a table for accessing data via Access forms
  66. Suggestions for table or query to track movement
  67. database strange behavior
  68. Re: i have a good 'schema, where do i go from here?
  69. Re: Help needed with table design/layout for newbie
  70. Re: Help needed with table design/layout for newbie
  71. Linking two tables - a bit different
  72. Core Competency Assessment
  73. Confused over new db
  74. RE: Making 2 colums into one
  75. "You attempted to open a database that is already opened exlcusivl
  76. Re: db design to calculate overlap in group membership in time
  77. Re: db design to calculate overlap in group membership in time
  78. My database loads but disabled?
  79. Hyperlink datatype
  80. Let's pick a replacement for this (Access) newsgroup
  81. Resource For Help With Access
  82. Thanks
  83. Changing values
  84. change cell color
  85. Allen Browne's 'Library Resource'
  86. Export Table Records to txt file
  87. 2003 to 2007
  88. Upgrading an .mdw to 2003 format?
  89. Employee Training Help
  90. Need help with table set-up and Thanks!
  91. RE: Employee Training Help
  93. Auto Increment by 1 Letter
  94. 2 Designers
  95. Populate a new field in an existing table
  96. RE: Populate a new field in an existing table
  97. RE: Need help with table set-up and Thanks!
  98. RE: Auto Increment by 1 Letter
  99. RE: Need help with table set-up and Thanks!
  100. Re: how to set a certain format
  101. RE: how to set a certain format
  102. Trying to Siplify a Query in MS Access 2003
  103. How to add record in Subform which is in another Subform
  104. Demise of News Group Forum
  105. Modify Northwind
  106. Accessing Database design mode
  107. Allen Browne’s Name table design
  108. "Click to add" column in Access 2010
  109. Relationship
  110. Filter Form based on OnClick from Text Box of another form
  111. How to change existing table record value by VBA and How to add newrecord in existing table by VBA
  112. Use Schedule Task to run Updates, but bypass User-Level Security
  113. Test - two recent posts never showed up
  114. designing form for inserting records into separate tables
  115. How do I record the date of the first record entry.
  116. Testing DB and .....
  117. Table design question
  118. move a primary key to a child
  119. Cross References Help
  120. Re: Search Form runtime error 2448
  121. Custom groups moving from assigned to unassigned.
  122. "Free" ip address in asset database, not remove?
  123. how do i activate the overtype function in access
  124. To index or not to index
  125. Re: Text wrap in column headings
  126. Re: Text wrap in column headings
  127. Proper Table(s) Layout
  128. Basic Layout and Design Help
  129. Update Table
  130. Can't insert columns into my access db
  131. "need good structure..." followup
  132. Re: Attendance Tracking
  133. System for Analyzing a database
  134. RE: #Name?
  135. Referential Integrity Q
  136. Multiple subtables
  137. Table Help
  138. Text Field Validation Rule for Date
  139. Access 2007 FE/SQL 2005 BE - Fatal errors occurring
  140. No Duplicates for Full Name
  141. Access ID
  142. referential integrity and lookup
  143. Please help! Designing database
  144. Adding records with referential integrity
  145. Re: Auto populate field in table
  146. fone color in table
  147. Skydrive
  148. Re: Auto populate field in table
  149. What are AutoNumber Dangers
  150. data checking
  151. Junction Tables
  152. Slow running reports
  153. Who is This STEVE... ? Does he really help.. Others
  154. Help... .. Deciding one to many or many to many.. Type..
  155. Default to data in a different table?
  156. RE: Automatic Annual Leave
  157. Re: Design for future merging
  158. Re: Automatic Annual Leave
  159. Re: Automatic Annual Leave
  160. Re: Design for future merging
  161. Creating links
  162. Link fields if found
  163. CaseManagement
  164. create and print payroll check w/office
  165. Fields
  166. One or two tables
  167. "object not supported" error when copying table
  168. how to get rid of "Add new field"
  169. Lookup field and Relationships
  170. Auto Populated a Table From SQL View When New Record Shows in View
  171. Access not enforcing referential integrity!!!
  172. Vehicle Waiver Database
  173. Using Lookup Query with Calculated Value in Table ComboBox
  174. Table relationships - hoping to just enter ID once in form
  175. What to do with 1.5 million records...
  176. Fields not showing up in columns
  177. Do I have to set the primary key to include primary key fields?
  178. sample database template
  179. Trying to combine multiple records into one record in a Query
  180. Make Table v. Append to Table: Need Some Expert Design Inputs
  181. count the nulls in a report calculation
  182. Linking forms and reports.
  183. Re: Compile: File Not Found
  184. Adding a button in MS Access
  185. Add table to split database
  186. Linked servers
  187. Re: How can I use relationships to auto-create records in my subform?
  188. AutoNumber
  189. Re: Splitting database - terrible performance
  190. RE: Splitting database - terrible performance
  191. Products/Services Table
  192. Disable Tables
  193. Circularly linking multiple records
  194. MultiSelect List Box (pre Access 2007)
  195. Search for Words in Documents
  196. HTML to RTF Access
  197. Re: Attachment data type - not working in form
  198. Re: Allowing Shortcut menu's
  199. Any advice? Creating forms on the fly
  200. Questions on SQL Server
  201. Text Field Size - Access 2007
  202. Interested in thoughts on keeping the integrity of historical data
  203. does this make sense
  204. Multiple id problem
  205. Two databases or one
  206. Anyone have a worker scheduling template
  207. Suggestions to Split Transaction details
  208. Creating Relationships
  209. Race timing in access
  210. Choices to display dependent on previous choices...
  211. Another relationship question
  212. Newbee Access DB structure help
  213. Table Structure Help
  214. Prevent duplicate groups of records in a table
  215. validation for one field based on another
  216. dumb data type question
  217. Crosstab query question
  218. many-to-many table setup?
  219. Importing of tables and other database elements into a new databas
  220. Building Composit key on the fly, Boy Scout Data Base
  221. pasted record in locked form crashes database
  222. To Zero or not to Zero
  223. Re: Linked Tables - indexes
  224. need good database structure for tracking counter state
  225. Purposes of Fields in Account trasaction template
  226. Database to track inventory in company cars
  227. formatting currency field
  228. Re: Database Runtime Question
  229. Setup ?
  230. work order form and report design help
  231. Table structure for separated families
  232. Proper Indexing of Table Fields
  233. Multiple instances of product in one order.
  234. RE: table / query design
  235. 2003 vs 2007 question
  236. Any suggestions
  237. create a database
  238. Getting a total in $
  239. Split database info not showing up on forms.
  240. RE: Beginner - 3 tables in 3 loops
  241. Re: Beginner - 3 tables in 3 loops
  242. Navigation Pane unhides when creating liked table
  243. Invoice database / report question.
  244. Change blanks to 0 (zero)
  245. Re: Lame Report Requirements
  246. Tournament Brackets
  247. Why won't Single take my number?
  248. Database for VBA
  249. Creation of New Database and Exporting Tables from an existing Dat
  250. Field Validation Rule to Exclude Ampersand
  251. Sorting data
  252. Re: Memo Field Truncates my Data in Table?!
  253. Re: Memo Field Truncates my Data in Table?!
  254. Re: Memo Field Truncates my Data in Table?!
  255. Re: A "push" function to produce an email on an event
  256. Printout Problem, error 2501
  257. Point of Sale database - does it exist?
  258. Help with database
  259. Table field length limit alternative
  260. How do I include more Help options for really inexperienced users?
  261. Re: No relation between tables anymore
  262. Re: No relation between tables anymore
  263. Re: No relation between tables anymore
  264. RE: No relation between tables anymore
  265. Building cascading lookups in an Access 2007 table
  266. Relationships
  267. help with database 2
  268. Clearing yes/no fields
  269. Items table Revisited
  270. Items table help
  271. I need help setting up my database
  272. Re: Normalization
  273. Re: Normalization
  274. Re: Normalization
  275. How do I setup a date field property that allows only Saturdays?
  276. Lots of Fields or lots of records
  277. Date Format
  279. String with Varying Letter followed by Incremented Number
  280. sync combox boxes
  281. Designing a patient management
  282. Help - is this possible?
  283. Sharing a database with multi-users
  284. Changing Template Design
  285. RE: help with database
  286. RE: Importing data from multiple sources
  287. Relationships
  288. design access
  289. access database
  290. Help with creating database
  291. Data Rules Violations
  292. how do I insert a hyperlink in my access database design?
  293. Access Services?? Accessing DB from web??
  294. Adding a second employee to an event
  295. Keeping data private per User in a multi user database
  296. help transition to access from excel
  297. Thanks to Allen Browne... and all MVPs.....
  298. Should this be one to Many or Many to Many.. Relationship
  299. Relational Database Layout
  300. Superclass have only a autonumber.. is it possible?
  301. Creating new row in other table
  302. Can you help me make a simple database / template
  303. unique record numbers
  304. database for tanning salon
  305. Form Design
  306. Compact & Repair Bug
  307. Intermittent locking problem
  308. how to increase resolution PDF and/or JPEG
  309. autonumber is it possible to link two fields
  310. Player availability list
  311. Student count for Class Registration
  312. Adding up days from Date/Time entered
  313. Set Mytable = MyDB.OpenRecordset
  314. Is there an option to zoom a form in design view to say 200%
  315. What does "tlkp" mean?
  316. AYS Link broken?
  317. Renewing member database design question.
  318. Auto Population of fields
  319. Switchboard buttons not creating
  320. Database Design and expansion.
  321. RE: Training database
  322. Restated: "Fields are expensive, records are cheap"
  323. header full line but page 2 rows
  324. I was told "Fields are expensive, records are cheap"
  325. Selective database splitting
  326. Make Query or Linked Table Read Only
  327. Church Database
  328. Conversion To Acc2007 or beyond Suggestions ?
  329. Assistance with Many-to-Many Relationships
  330. Append Query and Autonumbering
  331. RE: Remote control of tabls
  332. Auto Complete field
  333. Modify existing table for more details?
  334. Efficient Table Design Questions
  335. Number format issue Access 2007
  336. Access table data type selections
  337. Set Controls Default Value from another Control
  338. Slow form, again
  339. How do I change the order that my records appear in in Forms
  341. Re:
  342. Dance Classes
  343. 1 to 5 relationship
  344. changing formats
  345. Primary and Foreign Keys
  346. Footer Totals
  347. Tab Order for Multiple Entry Form. Vertical not horizontal tabbin
  348. Sharepoint
  349. Re: Field format
  350. Relationships
  351. where can i get transport industries database
  352. Calculating percentage from eneterd values within a table/form
  353. Switchboard is always covering other windows that open
  354. Access 97 won't save changes to form design view.
  355. Access 2007 Table Issue
  356. Re: Can we put two or three sets of data into one combobox?
  357. Part and Product Database Help
  358. Unexpected Delete
  360. Duplicate Fields Problem in My Tables
  361. Pen Mode in Access 2007
  362. i want to know more about report
  363. Re: Extra relationship
  364. No duplicates wanted in column except for default value...
  365. Web Database
  366. remocao de virus manuntencao redes windows vitoria-es 62992
  367. Radio buttons
  368. Allowing both multiple values and list edits in Lookup field
  369. Design assistance requested
  370. Filling in voids in the id number
  371. Display Row Number in Datasheet View
  372. Website Integration
  373. best way to archive records?
  374. Table & Relationship Advice
  375. Relationship Layout
  376. Creating a membership database
  377. Re: Help with table design
  378. multiple back-ends
  379. Re: Help with table design
  380. Linking to record in form view
  381. Data Type in Design View
  382. Lookup needs to fill two fields
  383. Access 2007 Table Header and Footers
  384. Creating Lookup Field Between Two Tables
  385. Are rows stored in fixed or variable length records.
  386. Changing Part-Number (Primary Key)
  387. Order Entry type form to add to three tables
  388. Re: Generate OrderNo by comparing the previous orders
  389. Table Design with Many Fields
  390. Re: records
  391. Re: records
  392. Problem with Group By & Max Rcd
  393. Data Entry
  394. Unbound Data Entry Form
  395. Lookup...
  396. An Inventory order and tracking db for hydraulic fittings
  397. One-to-One Table keys
  398. Print reports with creteria - 2 questions..
  399. Relationship not producing expected result(s)
  400. Access 2007 MSACCESS.EXE consuming RAM
  401. How do I do a summary of my records
  402. Refresh problem on form interface.
  403. Query Confirmations still opening
  404. Dance class
  405. Importing Tab Delimited Text File to an Existing Table in Access
  406. Rookie-building DB-want to get right the first time! Help?
  407. splitting database
  408. Text Field is Now Combo Box
  409. designing an engineering drawing db
  410. How Can I Eliminate the "+" Sign When Displaying Table Data
  411. Table relationship question
  412. costing problem
  413. Subtacting AvgSales by Year
  414. How to design a table or table to take an x, y control columns andall the possible array values
  415. Organising External Flies
  416. Re: CRM sample database
  417. Trouble with split database
  418. database for pest control
  419. ms access 2003
  420. Default Value =now() in table
  421. Scheduling Database Template
  422. If you buy the world's best and the cheapest batteries will not blame me
  423. Time Input Mask to show "5:35pm" ONLY
  424. Creating Relationships between tables
  425. Unable to copy objects between my projects.
  426. ICON
  427. tracking from a query to a table
  428. Date Calculation
  429. Shared Data Types
  430. Email Validation
  431. Linking Command Buttons
  432. Changing the name of a table that then relates to a query
  433. Option Group and Combo Box
  434. Help with normalization
  435. VSFLEX3.OCX install
  436. One-to-one relationship
  437. Re: How to change the path to a split database file
  438. Filter Combo Box by Login ID
  439. Re: I cant see my fields in form view.
  440. Re: I cant see my fields in form view.
  441. Avoiding Redundant Records
  442. como corregir el error:No se reconoce el formato de base de datos
  443. Export Issue
  444. Duplicate Values in the index, primary key or relationship
  445. Question and Answer tables
  447. Prospective Client Tracking Database
  448. Table relationships and lookups
  449. Report page break problem
  450. How do you normalize a table?
  451. Multi-field Primary keys
  452. Tables and relationships?
  453. Re: How do you get rid of a lookup field
  454. MVPs out in force
  455. Re: How do you get rid of a lookup field
  456. Linked table shows up as "~TMPCL###.." in Front end db
  457. How to respond to a job performance review?
  458. Command Buttons in a Form
  459. RE: need help with query or report
  460. Re: need help with query or report
  461. i need to do a restaurant menu
  462. Adding automated content to existing fields
  463. Recordset with data joined from 2 tables?
  464. parameters
  465. Insurance Certificates Database
  466. Lookup Field Issues
  467. linking tables for maximum efficiency
  468. Access Log in
  469. Tables and info
  470. Avoiding duplicate fields in a table
  471. Ensuring only one commission per product in Access Table
  472. Which table to put fields in?
  473. Data Fields Changing
  474. Combo Box
  475. Importing data from excel spreadsheet
  476. Re: Does Access store data in fix lenght or variable length records?
  477. Can't change data type
  478. RE: Report
  479. RE: Report
  480. MS Access file
  481. Re: Does Access store data in fix lenght or variable length records?
  482. Does Access store data in fixed lenght or variable length format
  483. Does Access store its data in fixed length or variable length rows
  484. can't change the data type or field size
  485. RE: Report
  486. FORM OPEN only show the header
  487. Allow Multiple Values check box not showing up
  488. Best way to design tables for cascading on my form
  489. RE: counting yes in yes/no data types
  490. Need Help with Totaling
  491. Lookup fields referring to tbls w/o relationship
  492. AutoNumber vs. Natural Primary Keys
  493. How do I break a link to an external database but keep table data?
  494. making a row height automatically adjust to cell contents
  495. How to design relationship between tables
  496. Look up boxes
  497. Design theory for maintaining historical address communications
  498. Blendcode table and multiple plants
  499. Data Validation Rule in Table Design
  500. help designing query to get results
  501. Set up my table
  502. Re: Pull Data From Multiple Tables ????
  503. What is clip art made of?
  504. Allow mulitpul users to see a linked excel table at once?
  505. Linking First & Last Names in a table to a Full Name field in anot
  506. stop the rounding
  507. Table structure for Course Attributes
  508. Proper table design for monthly tracking of activities
  509. Re: Player Statistics
  510. Re: Set auto#
  511. Show all from tables in my junction...
  512. Blank Field in Form
  513. How do I save the date a record was last modified in Access 2003
  514. auto number
  515. Budget Table
  516. Access Many to Many relationship
  517. Economical Auction Site
  518. can I use Access for Stock Trading analysis?
  519. Dear Abby - I have a Relationship problem - so slow its un-usable
  520. Relationship Help
  521. design help needed
  522. Re: Option buttons for subform viewing
  523. Needing help automatically generating info from a table to a form
  524. "expression in argument 3 invalad value"
  525. Access 2003 Look up field not displaying properly
  526. Dates Validation for Overlapping & Gaps (Leo asked)
  527. Binding fields from PDF to Access
  528. Change all Names: objects, fields, code, etc.
  529. Limitations on WHERE Clause in lookup query for a table column
  530. a Challenge for me
  531. Importing of TABLES TO A BLANK DATABASE
  532. Re: ACCESS version migrating from 2003 to 2007
  533. Looking for a template for all the websites I manage
  534. Appending Excel data into an Access table while inserting the file name
  535. Food Pantry Database
  536. Re: Access 2007 Does Not Confirm Design Changes
  537. Enforce Referential Integrity not available.
  538. Set up db to lookup and concatenate large amounts of text
  539. Data Type
  540. Hidden Field in Datasheet view for a table
  541. Re: need band-aid for poorly constructed db
  542. RE: "Normalizing" imported data
  543. RE: need band-aid for poorly constructed db
  544. when to use many-many relationships or different data bases
  545. Re: "Normalizing" imported data
  546. RE: relationships of 3 tables
  547. Re: "Normalizing" imported data
  548. DB guide
  549. "Hexidecimal" Index
  550. Re: relationships of 3 tables
  551. Design Mode Button?
  552. 'bad filename or number' in access erro when trying to split datab
  553. RE: Sum based on subforms
  554. Does a free HOA template exist (locations, owners, billing, fines,
  555. finding my product key number to install it on another computer
  556. Design Question. It works now...but how to redesign it?
  557. "recover access database"
  558. RE: Unable to have multiple useres share database concurrently
  559. Unable to have multiple useres share database concurrently
  560. Access Note table in date order, when go to note form, dates are n
  561. Access 2007 Note table in date order, note form is not. What can I
  562. Locate a table using VB
  563. Many to Many Data Integrity (Alway confuse myself)
  564. How do i recover a database lost during compacting?
  565. Temporary Variables
  566. How do you prevent the mouse wheel moving to the next record?
  568. Linking Tables
  569. Look up tables vs. value fields via combo box on form
  570. Look up tables vs. relationships design
  571. Table vs. query in forms
  572. Best Practice
  573. What tables and fields should I use?
  574. Best way to setup a field if different info needed based on type
  575. Access2003 - Relationship
  576. Creating a query to select 1 of 3 tables
  577. Re: Filtered Form
  578. Need template or "how to" for tracking daily/hourly animal activit
  579. Challenge: One table associated with several fields - but avoidin
  580. Search on one field & fill in the correct matching record
  581. Table Design - Spreadsheet-like data
  582. Change default value without influencing old records
  583. Re: How do I create a form with multi-tabs
  584. How can I set one field to return data into another field?
  585. Design Questions
  586. Re: Avoid redundant table design
  587. Asset tracking design problem using MS Access 2007
  588. Military Unit Database
  589. Re: "Rewrite" an application without affecting old calculations
  590. RE: "Rewrite" an application without affecting old calculations
  591. Re: "Rewrite" an application without affecting old calculations
  592. Re: "Rewrite" an application without affecting old calculations
  593. Use of a Date Field in Primary Key
  594. Relationship Question
  595. Re: Have I reached MS Access Limitations?
  596. Brain Cramp Db design
  597. Re: New to the whole DB world
  598. New to the whole DB world
  599. Re: Have I reached MS Access Limitations?
  600. Re: Setting up Observation Database
  601. Re: Setting up Observation Database
  602. multivalued lookup columns
  603. Invoicing database
  604. Re: changing info layout
  605. new db with 25 items w/ different types of amounts
  606. Collecting form data offline
  607. How do I link one person to another in the same table?
  608. want to save the record number in a field
  609. How big a record size is too big from a performance standpoint?
  610. Records in Listbox Identified in Reverse Order
  611. RE: training database - required training per employee
  612. Database Schema help
  613. Classification and the role of special tape
  614. Re: splitting a database, where question
  615. Re: splitting a database, where question
  616. access 2003 (sp3) The program stops responding
  617. Re: new table from same data as report
  618. Calculations in Access 2007 Reports
  619. Left function
  620. Best Practice Value list or linked table?
  621. Look up wizard in tables
  622. Access Database
  623. Your Input and link record to the date it is entered
  624. Two-line fields
  625. one to many or many to one
  626. Suggestion - Make a new section for Templates & Example Databases
  627. Re: What tables forthis database
  628. autonumber not working
  629. Questionaire
  630. coin collecting database
  631. Sum of field value based upon multiple instances of another value
  632. Need help with calculation if field is null
  633. Nested combo box
  634. Sum of every page in a report
  635. RE: Need a little help with syntax
  636. Table design help!
  637. setvalue macro
  638. where can I find Dallas Cowboy clip art?
  639. referential integrity and tables
  640. Design with no experience
  641. Re: 2 different Qty in order details in northwind
  642. command button not opening related fields
  643. Help with pivot table
  644. how to handle meter readings
  645. shipping database
  646. Format of temporary variables
  647. how to best structure this?
  648. Re: Need a little help with syntax
  649. Store similar types of records all in one table or separate tables?
  650. (Object invalid or no longer set)
  651. Field Privacy
  652. Date Format
  653. Re: Show employees and others in combo box
  654. Appending table autonumber problem
  655. RE: Need guidance for Inventory dbase, want to avoid calculated field.
  656. Invoicing database design
  657. Access auto numbers
  658. Re: Need guidance for Inventory dbase, want to avoid calculated field.
  659. Re: Need to have two autonumber fields in one table
  660. real estate database design
  661. Re: Need guidance for Inventory dbase, want to avoid calculated field.
  662. Re: Need guidance for Inventory dbase, want to avoid calculated field.
  663. Re: Strategy for groups within recordset
  664. Where should relationships be created?
  665. Defining Relationships/Primary Keys between two tables
  666. no political relations in internaional ....
  667. Re: Relationships bwtween more than one table
  668. Need help with several many to many relationships
  669. Data of many records of 1 form to populate another form via Cmd bu
  670. Tracking competencies with Access 2007
  671. Form Design
  672. client/server setup
  673. Database Design
  674. client/server setup
  675. Re: how to make name table and purchase table join and get data of sales?
  676. Linking Two Tables
  677. combo boxes
  678. DVD Movie Database Question
  679. Organizing Table
  680. Re: Relationships bwtween more than one table
  681. Re: Relationships bwtween more than one table
  682. simple address db question
  683. Multiple Many-to-Many relationships
  684. Student class payments
  685. table/database question
  686. Need a database that I can use for a consignment store
  687. Making a Database for 14,000 providers in Access 97 need resources
  688. linked ODBC tables
  689. Table validation rule - allow only one occurence in a field
  690. Random test generator
  691. Recording the frequency of Yes/No Fields
  692. Developing a new DB; Organization, Relationships, Cascade Update..
  693. Query Speed
  694. Linking an ID number to a name
  695. Non-limited table relationships
  696. Rule to prohibit someone from working on a project or in a time sl
  697. Re: Can't see choices in lookup drop-down
  698. Re: Can't see choices in lookup drop-down
  699. Appending a table by adding only records who are not duplicates
  700. I have no "Attachemtns" option in access 07. Is it an option?
  701. setting parameters for numbers in a column
  702. Share a Db
  703. Re: Personal Vendetta - Clinically Obsessive
  704. Monthly Vendor Report
  705. Need help to figure out a strong look up for pay tables
  706. can you change from one template to another
  707. Problem using Date() for default value in my Date/Time field
  708. Relationships between tables and querys
  709. Re: Personal Vendetta - Clinically Obsessive
  710. Re: Personal Vendetta - Clinically Obsessive
  711. Re: Personal Vendetta - Clinically Obsessive
  712. Creating work queue list
  713. using a date as archiving trigger
  714. My database is deleting rows by itself??
  715. top 5%
  716. UNC Question
  717. Date Format
  718. Linking Multiple Front-end Database Files
  719. Database Design help - Newer user
  720. Choose Profile pops up when going into design mode in Access
  721. database bloat/size
  722. data validadtion
  723. recording multiple session dates for regular clients
  724. No Record Display after Click
  725. Re-number an Autonumber
  726. Re: Adding two fields to Equal one Field
  727. Re: Adding two fields to Equal one Field
  728. RE: Adding two fields to Equal one Field
  729. Database management project of video shop who does sale and purch.
  730. EZNoDocLoans.com Unsecured Business Loans! No App Fees!
  731. A2007 - OLE vs. Attachements
  732. implemting lookup tables?
  733. Access keeps rounding down my numbers in a number field
  734. Code to gather information
  735. Using the date on one form to limit the records from another table
  736. Basic database design - using tables to feed lookups
  737. Form & Subforms
  738. New User - Linking tables
  739. Form Filter
  740. Seeking Advice on setting ErrorTracking DB
  741. HELP! with database design
  742. autonumber question
  743. Database Design and Import
  744. 2009 Calendar
  745. Input Help
  746. ACCESS 2007 setup and emailing thoughts
  747. Form Design advice
  748. Link updates are very slow
  749. using a IIF statement with a Like statement
  750. Not able to enter Chinese 4 byte characters(GB18030)in MSAccess 20