Tables
in [Access]
|
How to design relationship between tables Help please, I tried to set up an Toner tracking DB, I have five tables so far 1. MakeID, Make 2. ModelID, MakeID, Model (to generate the Model based on Make) 3. PrinterID, ModelID, SerialNum, MacAddress 4. TonerID, ModelID, Toner, Price (each Model has one or more toner) 5. Invoice, PrinterID, TonerID, Date, Q... 11 Jan 2010 09:46
Look up boxes I have created a look up table and the fields are SuburbID (primary key) Suburb, State, District, Map Ref. Then I have created a form that allows me to put in addresses of companies and my question is - how can I, on this form, select the suburb from a drop down box and it automatically comes up with the stat... 6 Jan 2010 09:47
Design theory for maintaining historical address communications I was curious to get some ideas for the best way to maintain the address of mailers that had been sent out. So by way of example we send out mailers or invoices periodically. And lets say they go to Joe Smith at 1 place last quarter. Now when Joe Smith changes his address we then send it to 2 Other Place. O... 6 Jan 2010 13:10
Blendcode table and multiple plants Toying with getting a cost system out of spreadsheets and into access. Most the tables are simple and easy to set up, but I'm debating our material blends table. We have multiple plants, about 10 materials, and each product may contain any percentage of 1, 2 or 3 of those materials. Each plant currently has ... 7 Jan 2010 15:50
Data Validation Rule in Table Design Can you tell me how to write a data validation rule I can use in the table design mode for a phone number field that will not allow blanks (eg Not null) and allow user to write N/A if phone number is not known or available AND allow user to type a phone number as (123) 123-3456 if phone number is available. T... 6 Jan 2010 09:47
help designing query to get results In my database of employees I have three date/time fields - Agency Start date, Rehire date (a lot of our employees only work part of the year) and Separation Date. If I wanted to show only the employees who have either started, were rehired or separated in a certain time frame, how would I do that? Example: Wh... 6 Jan 2010 09:47
Pull Data From Multiple Tables ???? Hi I will have 4 tables name "TblCostomers","TblVendors","TblAccounts", TblExpenses" Now i have a for name "FrmDrVouchers" that has a table "TblDrVouchers" in source. This form has two TxtBox Control name "TxtAccountNo" and "TxtAccountName" If User enters a Account No., It pulls the Account Name from Any One ... 31 Dec 2009 11:00
Linking First & Last Names in a table to a Full Name field in anot Hi. We have been using Access for a project database for years. However, we just added our customer information (formerly in ACT) to Access. Now I have two fields in our contact table (First Name, Last Name) but only one field in the existing project table (Full Name). I would like to link the customer to h... 29 Dec 2009 17:31
Table structure for Course Attributes I have a database which stores information about courses. This Course table structure is very simple: CourseID, Description, Title, etc. I need to store other information about the courses, but this information is more irregular. I was thinking about creating a CourseAttribute table with just a few fields: ... 29 Dec 2009 17:31
Player Statistics Hi, I have an access members database, quite extensive. I also have a members excel file which details frames won and lost in each match for the season (8- Ball Pool). This will then calculate a members "statistics". I would like to incorporate this all into access but I cannot get my brain into how. How do I rec... 28 Dec 2009 22:54 |