How many tables would be needed Results

How many tables would I need for the following:

Order#
customer
date/time order received
date/time order due
courier (the order might be shipped via two or more different couriers)
dept (the order might be sent to three different depts.)

the order will be for making photocopies of different sizes
and different width

If I need to provide more information, let me know.
Any help would be appreciated

Thanks.

Hi there, have searched the forums and got some ideas but am totally new at this. I have built a database but it's not doing what I need because I'm not sure what structure, how many tables to use. I'll tell you what I need a database for. Hopefully you'll have some suggestions (I know you will) to get me straight. This is pretty simple compared to the complicated stuff I see on the forums. I have a club of young children. Ages range in from SK to Gd 8. Each child needs contact info obviously in order for emergency weather call list, mailing labels etc. to be made. Here's my problem. Some children belong to same family with different last name. Do I put siblings in same table? Different table for sibling1, sibling2 etc.? How do I create a form to input these into the same family. I also need to be able to pull up reports for the children in each separate club. ie. Sparks, T&T and Trek. T&T has girls 3&4, girls 5&6 and boys 3&4, boys 5&6. Hope I've outlined this ok. Happy to answer any questions. Any suggestions you can give me to get me going would be great and much appreciated. Thanks for your time.

I am trying to add a new dimension to my database and have a table for 'Committees'. There are several diferent committees overseeing different tasks, each commitee will have a CommitteeID, description, Date formed, Date disbanded and field called 'office'. The idea was that the DB user could open a form and amend or add a new 'committee' electing a chairman(Office) secretary, Vice Chairman etc. The members elected to the committee can only be members of the club i.e they already have a membership number, and their data is stored in the tblMembers. I tried using a sub form of committee members but cannot get it working I keep getting problems with duplicates etc. Members are 'autonumber' as is committee ID bearing in mind you can have 1 member on several committees, and each member can take a different office after a period of time etc. Im getting confused now which is the best way to set up the tables and indeed how many tables I really need to store committee, committee members etc. Ideally I would like a form that you can use record selectors for to find a committee and have a page (tab) to enter members relating to the committee displayed on the first page. I know this is about forms but I need to work the tables out first.

Design Idea:
I have been given the task of tracking the progress of every Serial Numbered Unit that enters the building. Progress Updates will be made by Repair workers as they complete any particular phase of the Repair.
Question:
Since I need to track multiple events to each particular unit, should I give each unit its own dynamically created table? We usually handle about 80 returns at any given time. This means a WHOLE LOT of tables. But, info will be easily accessible and easy to put into Reports.
Suggestions Would Be Appreciated

Hey all!

I have sort of a random poll for everyone.

I’ve been working on a payroll project and as I’m a student and most of the things I had to accomplish for this project I’d never seen before, its’ taken me hours upon hours to code it, but I was curious as to how long (an estimation) something like this would take a professional to do.

So the task was this:

Create a database to store the details of an employee (name, surname, id number, date employee began working for company, project num (which project he/she works on), occupation num (what type of job employee has), bank number and then provident fund and union dues, if applicable (fee’s that get paid directly out of the employees wages, if applicable)

Each job has a different hourly rate, as well as 3 overtime categories, which are worked out based on the normal rates hourly pay (calculated whenever a new job category is added or the normal rate value in a job category is changed). There must be a table that stores each employee’s hours worked for the 4 categories (normal hours and 3 overtime categories). An employee can also receive any number of other payments and allowances (i.e. travel compensation or if they take a loan from the company). Other pay and allowances must be stored in separate tables.

Before a pay slip can be generated, the following must be calculated for each employee:
· Wages (hours worked * hourly rate, therefore there are 4 categories of wages)
· Gross wages (all 4 categories of wages combined)
· Total allowances
· Total other pay
· Total Income (all incomes combined)
· UIF (1% of gross wages)
· Total deductions (all deductions combined)
· Nett Wages (total income – total deductions)

A few other forms must be generated, such as a breakdown of the different monetary values an employee receives, if he/she is paid in cash.

An application program must be created that allows users to access the various tables to view details and add/delete/edit where needs be (i.e. add a new employee to a system, edit the amount given to an employee for travel compensation, etc)

That about sums up the task. Now to the question:

How many hours would you reckon it would take you (working on your own) to complete a task like this (excluding doing documentation of it, i.e. just the coding, creating of the database and queries, etc)?

i am new to reports but i thought i would give it a try to see how many items i have sold.

im not sure if i need to create a query or if i can just do it through creating a report.

i am wanting to know how many treatments i have sold. i have a table that stores all the treatments that have been sold and i want to build a report that says you sold x of a x of b and x of c.

can someone please advise on the best method for this. if it is a query that will have to do this then i think i would prefer that as i want to be able to say within these dates further along the line.

thanks

Hey guys,

So I stoped by the Query section and spent a few days trying to figure out how to make a query that will allow me to count how many open records I have each month.

That thread can be forund: http://www.access-programmers.co.uk/...d.php?t=214642

It might be a good idea to scan over that as that for more info.

Here is what I am looking for:


I have two dates: AwareDate DateClosed I need to create a report that shows, by month how many records are open, so if I had 15 records open in 1/1/2011 and they all closed on 3/1/2011 my end table should show.

1/1/2011 = 15
2/1/2011 = 15
3/1/2011 = 15

The issue with SQL is that I can group by month, BUT since there are no values for 2/1/2011 and 3/1/2011 I cant get a count, the output would look like.

1/1/2011 = 15
2/1/2011 = 0
3/1/2011 = 0

If there is a WAY to do this in SQL alone I would love to know but at this point I belive we will need a function to do the math.

I am kinda new to looping over tables of data so any advice or direction you can provide would be great!

Hi Guys,

I didn't know where to post this, but i figured some VBA would be needed somewhere.

Okay so;

I have a table 'PARTS', below is a small example:


	Code:
	            PARTS
   PART         MODEL A      MODEL B 
     X             5           6
     Y             6           7
     Z             8           3
     H             3           2
     J             2           1

Note, there are around 600 different parts, and up to 100 different models. Also the data is shown in a 'parts' form, where a part is selected and then a text box for each model displays the amount that model uses of the part.
__________________________________________________ _______
Next i have a query called 'SALES', below is a small example


	Code:
	     SALES
   MODEL         SOLD
     A            3          
     B            12           
     C            9           
     D            20           
     E            230

This is updated live when a new product is sold.
__________________________________________________ ____
Next I have a table 'STOCK 6/6/12', below is a small example:


	Code:
	  STOCK 6/6/12
   PART          STOCK    
     X             50                 
     Y             45                 
     Z             32                 
     H             60                 
     J             50

__________________________________________________ _

I need to show on a table or query the available stock.

This is the idea i have:
I need to multiply the sales times the amount of parts that are used in each product, this will tell me how many parts to subtract off the stock.

The tables and queries cannot be changed unfortunately.

Thanks for your time

,Leon

I have a simple database - 4 tables, 10 records in each. It's for a fictional company called DC Glass; it holds customer information and order information. I need to put some sort of VBA in it; I want to know what I could use VBA for (no matter how useless it would be in relation to the intended purpose of the database).

This is for part of an assignment I'm doing in college - I havent had a tutor for about three months and when he was there didnt teach us any VBA, despite the fact we need to know it....

you wouldnt think a tutor in a college would be too much to ask for, its like a bar without beer

any ideas would be great, or any examples/good websites on VBA would be good

so far the best idea ive come up with is a few message boxes, I know a good bit of VB .NET, so im hopeing ill be okay with writeing VBA code
Many thanks

Good day folks,

Hopefully someone will be able to help me, I have created a table which has 28 fields of which one is a date data type and the remainder are numerical data types. The table is named tblStats.

I also have a table that receives data from text files on importation. In this text file is a couple of fields that contain the information I need for my tblStats table. The name of the destination table is tblDDMandateImport.

I have created a process that automatically imports the data from the required text file into my tblDDMandateImport table.

Within that process I have written code that counts specific data types as shown below:

#############
BEGIN CODE
#############

Dim ADDB, ADDD, ADD0, ADD1, ADD3, DDIB, DDIF, DDIG, DDIH, DDIK, DDIL, DDIN, DDI1, DDI3, DDI5
Dim REJB, REJ0, REJ1, REJ2, REJ3, REJ4, REJ5, REJ6, REJ7, REJ8, REJ9, STD4

ADDB = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""ADDB""")
ADDD = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""ADDD""")
ADD0 = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""ADD0""")
ADD1 = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""ADD1""")
ADD3 = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""ADD3""")
DDIB = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""DDIB""")
DDIF = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""DDIF""")
DDIG = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""DDIG""")
DDIH = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""DDIH""")
DDIK = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""DDIK""")
DDIL = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""DDIL""")
DDIN = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""DDIN""")
DDI1 = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""DDI1""")
DDI3 = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""DDI3""")
DDI5 = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""DDI5""")
REJB = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""REJB""")
REJ0 = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""REJ0""")
REJ1 = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""REJ1""")
REJ2 = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""REJ2""")
REJ3 = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""REJ3""")
REJ4 = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""REJ4""")
REJ5 = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""REJ5""")
REJ6 = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""REJ6""")
REJ7 = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""REJ7""")
REJ8 = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""REJ8""")
REJ9 = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""REJ9""")
STD4 = DCount("*", "tblDDMandateImport", "[strLetterCode]Like ""STD4""")

Dim Total As Integer

Total = ADDB + ADDD + ADDD + ADD0 + ADD1 + ADD3 + DDIB + DDIF + DDIG + DDIH + DDIK + DDIL + DDIN + DDI1 + DDI3 + DDI5 + REJB + REJ0 + REJ1 + REJ2 + REJ3 + REJ4 + REJ5 + REJ6 + REJ7 + REJ8 + REJ9 + STD4

###########
END CODE
###########

What I would like to do is assign the value of each of the above variables to the appropriate fields in the tblStates table, field names as follows:

strADDB
strADDD
strADD0
strADD1
strADD3
strDDIB etc etc

I have set the date properties field in the tblStates table to always use the current date.

So the idea is that each day the data is imported into the tblDDMandateImport table my code counts up how many records for each letter type Code [ADDB, ADDD etc] and then populates the tblStates corresponding fields with that value. Each time the process ran a new record in the tblStates table would be created, something like this:

dtmDate strADDB strADDD strADD0 strADD1 strADD3 strDDIB etc etc
16/04/08 15 10 5 30 1 9 etc etc
17/04/08 35 5 9 45 0 18 etc etc

I hope the above information is sufficient for a response, your assistance would be most appreciated.

John

Hi everybody.
I've been working with a database in Access 2003 which I wrote a couple of years ago, but it is now starting to show it's weaknesses and needs a vast overhaul.

It's purposes are:
Keep stock of equipment in the AVA department.
Record loans of equipment to staff and students.
Track when items are broken or need servicing.
Notify us when items are overdue for return.

Currently, if somebody wants to borrow a laptop, projector and six cameras, I have to input the data for each item seperatly, this takes a while, putting the start/end date and times, location, person borrowing the item etc. for each item.

Also, I need a way to stop my partner who's not very computer literate from accidentally deleting or overwriting users in the database, which she's done many times now.

Another problem with the current database is that there is no checking for duplicated or clashing entries.
I just noticed too that in the relationships for my old database, I didn't have any of the referential integrity things selected either!

I've decided I need to start it again from scratch since there are so many things that need changing with it.
I have found some code on this site to sort out the clashing bookings issue, which I am hoping to get working with the new system, and I found a post referring to an AV booking system from 2005, but I didn't really understand what they were telling the original poster to do.

Can anybody give me any pointers as to how to go about making the new version better, easier to use and do what we need it to do?

The new version needs to...
Check for duplicate entries.
Allow accurate stock taking of equipment.
Check for clashing bookings. - I have this working I think.
Allow me to book out multiple items per booking.
Preferably allow me to select items availble to book from a list that gets updated when items become (un)available.
Alert us when items are overdue. - I have to do this manually at the moment.
We are also implimenting barcode scanning for our equipment and staff badges so would need this working too, but they're just like normal keyboard entries really so it shouldn't be difficult.

I've attached an image of my current tables and relationships.

The TblEquipment... with just BookingID and EquipmentID is my attempt at making a list of items per booking, but I don't think it will work the way I was thinking. Also, I'm not sure if the TblRooms table would be needed or not, I just put it in to reduce the amount of typing I'd have to do for putting room numbers and names in different tables.

Sorry for the long first post, but hopefully somebody will be able to point me in the right direction

Before I begin, I will openly admit that my knowledge of Access is pretty limited, and that I am learning as I go.

I have built a few databases, although each has been a development of the the one before it so more developing, refining and expanding what I have done before; the latest version is proving to be highly successful now that it is in operation - I should say that it is fairly simple (I would imagine that most of the experts on here would build it standing on their head), in that it has a form which users simply enter information into the relevant fields which populates the table, and then reports can be taken within given parameters (main one being date from and to).

However that success has led to me being presented with new challenges, as more and more people are seeing the benefit of being able to get access to the information they want quite easily.

The latest one has me totally lost, hence me turning to you all for help, simply because it involves moving or displaying information in different locations.

In short, I have a fleet of vehicles (up to 150), and each vehicle is fitted with four items of equipment; each item of equipment has a serial number. I need to be able to track those items of equipment coming into stock from the supplier, then onto each individual vehicle, as well as being able to go back into stock and even back to the supplier.

There is only one supplier, and each vehicle has a unique ID number. The four items of equipment are entirely separate to each other, and it is common for only one of them to be changed out at any point in time.

I need the database to be able to show:

- what four items are on which vehicle at the time of the report, be that an individual vehicle report or a full fleet listing;

- what items are in stock

- the history of an item (which vehicles it has been on, and if it has been in and out to and from the supplier a number of times)

This may sound really silly to most on here, but I cannot even work out how many tables I need for this - and I would openly admit that relationships has me baffled.

Any, and all help gratefully received

It is a textbook inventory database for the local high school. It has a student info table which has a students first name, last name, id number, and grade. ID Number is the primary key. This ID number is stored on a student ID card which is scanned into a form when a student comes for a textbook. Then I have a textbook inventory table which has a book's barcode label, title, and other publication information. Next I have a Student Checkout table which has the student ID Number and book barcode number as well as fields for the date it is checked out and the date it is returned. The primary key is both StudntID and BookNumber. They are linked to my other 2 tables. I created a form with text boxes for the student ID(from the checkout table but i created a relationship to the student info), student last name(from Student Info) , and student first name(from Student Info). It then has a subform with Book number(from Student Checkout but related to Inventory), Book Title(from Inventory), DateOut(from Student Checkout) , DateIn (from Student Checkout). I designed it that way so that the students ID would only have to be scanned once no matter how many books were being taken. However after scanning(or entering manually) a students ID number when i click the box the book must be scanned to gives me an error saying i'm trying to save a null value in the primary key field.

WARNING: LONG POST
I know there have been plenty of discussion over inventory control but I have a situation with some additional variables and I need some heads to bounce ideas off of.

I work for a custom cabinet manufacturer and I have a database that I developed that we’ve been in use since 2001. There are several different components to the database, but the last one to be completed (and the one I’m working on now) is job costing.

PROBLEMS/CONSIDERATIONS
Problem #1: Since we are a manufacturing company we use many different materials to make any one product. So far I have all items ordered (since 2001 anyway) in the database but to date I don’t have these items allocated to any particular project – hence the need for what I’m talking about here. One of the unique problems I’m having is the fact that some items are ordered for a particular job (I.E. you know what job they are for at the time of ordering) and some items are “stock” items, meaning that we always keep a certain number of units on hand.

Problem #2: Another unique problem (relating mainly to “stock” items) is some products we use are ordered from different vendors (depending on availability, price, ect.) These products are essentially identical and need to be grouped with other like products at the time of assigning materials to a particular job. On the surface this problem sounds like an easy fix just by grouping the same product name across all vendors. However, it’s not quite that easy because we have many different stock items and product ids are different from vendor to vendor (and I always tell users to use a vendors identification for the product ID and they can use the product description to clearly identify it for our users). Another problem is I have users that are not disciplined enough to keep track of how they named a particular product previous ordered from a different vendor. Therefore I’m convinced I need another method of identifying like products across vendors.

Problem #3: Lastly, I’m still trying to figure out if I should subtract current stock or calculate it anytime “on hand” numbers are needed. Any thoughts on the best method (keeping in mind the variables listed above) would be greatly appreciated.

MY SOLUTION IDEAS
Concerning Problem #1: I want to allocated materials to a job at the time a work ticket is written (this would be the most logical input location since any given work ticket deals with a fairly small portion of an overall job and a material summary at that point is typically already given by another program or would be easy to figure by the person writing the ticket). I would like to do a material input form that would list only materials that have been ordered for the job and then either call another form for stock materials or have a switch to show all stock materials. What I’m unsure of: will I run into problems selecting both from the same form (since they’ll most likely run from different queries) and how will I pull stock items from multiple vendors (i.e. I used 10 sheets of particle board: We have 5 sheets left from vendor #1 and 7 sheets left from vendor #2). – Any thoughts on better methods and/or ways to improve database structure?

Concerning Problem #2: My main thought on combining like products from different vendors without requiring that the product ID match exactly is to enable a “Universal Product Code” anytime a product is tagged as a “stock” item. In the product entry form this would be a combo-box so the user has to select from a list. – With the amount of data I have so far I think I could create a fairly comprehensive list and furthermore my hope would be that if a user had to go to the extra step of adding an item to the list – he/she might think a little harder about properly coding it. – Thoughts/suggestions?

Concerning Problem #3: Given the considerations previously listed, I would ultimately like the database to accurately track inventory so when I order a laminate (or anything else) for a job and we had some left over from a previous job I could see that at the time of ordering. This would also save us time while entering work orders because we could see at the time of release that we are short of materials instead of waiting for the ticket to get into production. Whether I use a subtraction method or calculation method, I still need to figure out how to allocated or indicate which work order the item was designated to. Any thoughts?

Attached is a PDF showing the relationships to my existing tables. Keep in mind that additional tables may be needed to implement the changes I’m talking about here. Also, I’d be glad to email my database to you if you’d like to take a look at it.

I apologize in advance for the naming conventions used in my database. This was my first database and some of my earlier work was done without the foresight of proper naming.

Hey folks.

I have an Access db needing populated via a worksheet with unknown # rows and known # of columns. Before pulling this data in I must do a row count to determine how many records will be added to the db. Otherwise, it would be a very simple thing to just copy the contents of the worksheet over.

Known:
- Only using DAO.
- The access table is already created matching the column count in the worksheet.
- The spreadsheet will have an unknown row count.
- Some rows in the spreadsheet will have various cells empty.
- A completely empty row will mean EOF.

Need:
- I need to determine how many rows are in the spreadsheet before copying into db.

Problem that occurs from attempt:
- Overflow issue. I seem to be counting every single row on the worksheet, even though only 2 contain data.

Any ideas out there? Pasting below my latest attempt.


	Code:
	Dim strStorage as integer
strStorage = CLng(xlsWST.Rows.Count)

Thanks folks.
-Tethys

I manage a training database that tracks many different facets of an organization's training needs. One thing I would like to see is something that shows how many people will be in training on any given day. For example, I would like to see a range of dates printed down one column, and in the next column the number of people in training. I'm not sure how to best do this, so I'd appreciate any help or guidance.

To give you all a little background:

- Classes can last several months
- I would like to be able to create a class, including the class name and the date range of the class
- I would then like to be able to attach multiple people to the classes
- I would then like to be able to look at a report like I discussed above, that counts how many people are in any class on any given day

- I currently have a table for all of the people in my organization (keyed by HRID).
- I imagine a table for each class, including the Class Name and Date Range (would I have to do each date as a separate field??).
- The final table would include HRID and Class Name to link the two tables and "put people into a class."

I'm really struggling with how to handle the date range, particularly considering each class may go on for 60+ days. Does anyone know how to do this?

Thank you in advance!

Hey guys,

OK, your gonna have to bare with me a little bit as its hard to explain and if any VB is given please add a few annotations as I have to explain everything i do in a report (doest have to be too detailed, just to make the code understandable ) and if it needs better clarification feel free to ask , but basically, I have the following relationship set up:

http://img512.imageshack.us/img512/3...nnshipswd9.jpg

At the moment, because of the way it is set up, I cannot create a record in the transactions table unless an income record is given for it (because tb_income (one) to tbl_transactions (many)) but the way I want to work is as follows:

If you have a look at the tables tbl_transactions and tbl_income and their link. The way I want the system to work is when a new transaction is made, a new income record in the "tbl_income" table would be made with the date (in tbl_income) being the date at that particular time and all transactions created on the same date would all go in the subdatasheet for that one record created for that date; and if another transaction is made on an alternate date (say 00:00am of the next day) another income record would be created automatically with the date being of that particular day etc.


My other problem im facing is that everytime there is a transaction created, I want the stock level(s) field of products in that particular transaction to be decreased by the quantity purchased of that product but i have no idea how to do so

Any help?

Thanks a lot in advance!

Daniel

Hi,

I have posted several questions regarding how to set up my database recently and i am now a little bit confused. I would appreciate anyones help on how many tables to use, relationships etc.

To briefly explain, my company has been awarded a contract to carry out safety checks on 6,000 main incoming meters for the UKs largest utilities provider.

My database needs to store the following info:

House No
Road
Town
Postcode
Date job completed
Completed by (engineer name)

Engineer First Name
Engineer Last Name

Then there are about 10x fields for Y/N answers to job specific questions
Job aborted
Reasons for jobs aborted

I know how to create queries and would be pretty confident with that. The queries will be:

jobs oustanding
jobs completed
jobs completed by particular enigneer in a particular week
jobs aborted - reasons (text field)

I just need help with the tables and relationships so they all link in together. I want to get the d/b set up the best way i can from the start.

One other thing i would like to do is allocate jobs on the job table to certain employees, would i do that using a new filed on the job table and then a combo box?

apologies for all the questions at once. any help will be greatly appreciated.

thanks

Hi All

I am trying to create a database for estimating manhours on projects. There is a setup table with two columns: "Project" and "Time Period". The database is supposed to allocate manhours to tasks on projects, which is used in estimating man hour costs and also forecasting labour resource requirements.

For example, say the database is used for "Project X" and "Project Y" projects, with Project X running from Jan to March and Project Y running from Aug to Dec. The setup table would look like this:

PROJECT TIME PERIOD
Project X Jan
Project X Feb
Project X March
Project Y Aug
Project Y Sept
Project Y Oct
Project Y Nov
Project Y Dec

From this table, I need to automatically create a new table for each unique project that allows man power to be allocated to each time period. Following on with the example, there are two unique projects, so two tables
need to be automatically created with column headings as per below:

Project X table:
FUNCTION PERSON JAN FEB MARCH

Project Y table:
FUNCTION PERSON AUG SEPT OCT NOV DEC

"Function" is a description of a role, for example engineer. "Person" is the individual undertaking that role, for example Bob Jane. Then in each time period a number between 0 and 1 would be entered corresponding to how much time (0 is no time, 1 is full time) that person would be spending on that function for that time period. Then the table would be populated with many functions and people in this manner.

So the number of tables automatically created depends on how many unique projects there are in the "Project" field of the setup table. The number of columns in these tables will be atleast two: "Function" and "Person",
plus another column for each time period defined for that project.

Perhaps something can be done with a make-table query, but all I can get that to do is copy data from one table straight into another table.

Any help would be greatly appreciated.

Thankyou in advance.

Joey

< I really like that smiley.

I am very glad to have found this forum, as I really need some help. I work for a non-profit and was asked to develop a database that would allow our services people to input data on employers that have been visited and track followups. I've tried to sort of use the "Access 2003 Inside Out" book by Viescas and elements of his LawTrack contact database sample. Confusion reigns supreme at this point. I've done some topical Access work before, and have even set up some simple databases using InfoPath as a front-end, but nothing this complicated.

I have the tables, and have attempted in multitudes of ways to establish the proper relationships. The most common problem is when trying to enter information into a form, at the point where it's time to enter contact information (three associated tables), I get that funny bell sound, and it won't let me enter proper information. A couple of times I noticed after completing all other fields and proceeding to a blank record, then coming back to it, it will then let me enter info.

I've changed the relationships and keys multiple times to no avail...

Here is the graphic of the relationships:


I need for tblCompanyContacts, tblEmployerContact, and tblContactEvents to talk to each other and to tblEmployerDemographics as there are many contacts to one employer and you might have many contacts for one employer but only one can be primary.

I'm thinking the contacts-related tables would be best nested as a subform in a main form....when I try to generate a form on those three tables using table wizard, I get a blank form I know the whole problem is how to use the keys and their relationships, but I'm key stupid at this point

Any thoughts?

Cheers,
Don B.


Not finding an answer? Try a Google search.