Deadline Getting Closer - Still Stuck In Table Design Phase

Feb 5, 2008

Thanks to all who have provided help on other threads. I have made some progress but I am still struggling with the last couple of relationships here. I am tracking projects and have normalized this data into the following tables:

tbl_customers (contains customer specific information)


Is on the "one" side of a 1:many relationship to tbl_workorders. (1 customer for multiple WO's)
Is on the "one" side of a 1:many relationship to tbl_locations (up to 2 locations per customer).
Is on the "one" side of a 1:many relationship to tbl_circuits (up to x number of circuit ID's for each customer)


tbl_workorders (contains order specific information)


Is on the "one" side of a 1:many relationship to tbl_costs (multiple costs for each WO).
Is on the "one" side of a 1:1 relationship to tbl_services (each WO can only have one row on the services table. I suppose I could combine all fields onto 1 table, but logically they represent different information. The WO table is about the work order and the other table deals with the customer's services.)
Is on the "one" side of a 1:many relationship to tbl_contacts (can be multiple internal contacts for each WO)



tbl_dates (contains as many as 33 possible dates for each project)

This table is one that I am having trouble with. Each work order can have any of the possible dates on tbl_dates. I have designed tbl_dates to be as normalized as possible. You select a date type and enter the date. I can't figure out where to relate this to tbl_workorders without using the WO field. Perhaps I am designing this table incorrectly.

Any help is appreciated. Thanks!

View Replies


ADVERTISEMENT

Very Urgent: Deadline Very Near, Help, Help, Help

Dec 20, 2007

Hi All

Please, please help as I’ve got a really urgent project to complete. If I don’t get it finished I’ll be out in the cold. I’m really struggling for time myself so I hope people here can help. Here’s the rub:

I got a list of recipients (names & addresses) each requiring a list of items (we have all the lists currently on bits of paper). The number of addresses and hence the number of lists runs into the millions so I need a big database. Will Access be able to do this?

We have all the stock in our warehouse in stock ready to pick. We use to hand make the stuff but now we just buy it in. So at some point I’m going to need a buying schedule (future development).

Contrary to popular belief we the deliveries to the recipients are over several deliveries (not one). What I need is a database that allows me to produce a schedule of which go on which delivery (essentially I do this by postcode/zip code). I need the schedule so the pickers know how to assemble each load. Also there’s a claus in the contract that say we have to have a delivery schedule for the guy doing the deliveries (the same guy – my boss – does all the deliveries). His missus is funny, she keeps saying to him “Look out for the rain dear”. Thankfully we never have to deal with returns so no issues there.

I there also a way to monitor which picker picks what because in the past some of them have been a bit crap and they should give themselves a kick up the backside.

I also need to produce a run of labels so that I can stick a label on each item saying give the name of who the item is for. Is this possible? It’s now joke having to write them all by hand.

One more thing. Some of the delivery points have been known to leave gifts when the delivery is made. We use to just accept the gifts and say nothing about it but now we need to record this as the tax man says because of the sheer number of gifts then this becomes benefit in kind and has to be declared. Thankfully the company vehicle is except from tax (at least for now).

I can’t offer any money for this. We’re a kind of charity. My deadline is 4½ days and counting. I really hope yule all help with this because it’s really important and if it’s not done I’ll lose my job.

I haven’t got very far with this and I really haven’t got time to do it myself. If someone could send a sample database of how I should start, that would be great.

Chris Stapphamy

View 14 Replies View Related

Deadline And I Need Some Assistance Please

Aug 10, 2005

I created a form using a text boxes by using the field list icon and dragging the field I wanted to make into the text box onto the form. In the properties of that text box, under the format tab I set the format for "short date". Under the data tab in the properties of the text box I put in the control source this forumla =DateSerial(Year([Date of Service]),Month([Date of Service])+10,Day([Date of Service])). "Date of Service" on my form is the name of the source field it calculates from. What the forumla does is calculates from the date entered into my Service Date field and whatever date is in that field it adds 10 months to it. This field with this formula in it caluclates the date of my contacting the customer to setup an annual service for them. I also have another field that calculates the annual service date using the same formula only changing the +10 to +12.

When the Date of Service it entered the Contact Date field automatically adds 10 months to the date entered into the Date of Service field. Same of the Date of Next Service field only instead of 10 months it adds 12. So my formulas are correct. However when I go to my table I can not see any of the caluculated dates entered into the table. I can see it in the datasheet view of my form. My question is how do I create a query to pull only contacts dates from this form for a specific time frame? When I attempt to create a query I can only see table fields which do not contain the formulas for calculating the dates. Or can the fields that calculate the dates on my form be linked so the calculated dates are linked into the table and updated on the table when I update the form?

Keep in mind I am new to access so please give very detailed and specific instructions on a solution for this issue.

View 3 Replies View Related

Age Calculations Help DEADLINE TODAY

Jun 20, 2006

This is probably an easy criteria but I'm getting close to COB and I have to have it in today.

I have a DOB as (DD Mon YY 04 Jul 79) in which I need to create a column for thier age. Then I have to show all the people who are over 60 years old. I can't even get thier age to show correct. Any help. Thanks

View 6 Replies View Related

Calculations Deadline Approaching Soon

Sep 21, 2005

Deadline approaching soon… HELP!!

I have three fields

Life Skills Credits Earned Total

I need to enter a number in the Life Skills Credits. The Earned field should continue to add what I enter in the Life Skills Credits, but I need the life Skills Credits to revert back to 0 (zero)

I hope I explain this right…..

View 4 Replies View Related

Email Report (UNDER DEADLINE)

Feb 24, 2006

I have a form with a subform. The form is the date field. The subform are all the stores delivered to on that date. I need to have a command button to open an email with the current date showing and list all the stores with their delivery numbers next to it inside the email.

View 2 Replies View Related

Displaying 'deadline' Dates Depending On The Activity

Feb 1, 2008

Not really sure how to word this as I'm not sure if I even understand.
Basically I have been asked to set up a database logging distubances and need to display on the form 3 different dates (action by, monitoring period and date to close case) from the date the data is entered, depending on the disturbance chosen.

So if there was noise nuisance the action date would be 7 days, the monitoring period would be 14 days and the closing date would be 90 days. This would be different from, say dog fouling. When the user chooses the disturbance from the combo box I need the dates to reflect the deadlines for that disturbance.

I have entered the number of days to add onto the table containing the disturbances (ie 7, 14 etc) and know how to add these days onto the original date.

How do I make this happen depending on the disturbance selecting.:confused:

Hopefully someone can help!

View 4 Replies View Related

Issue With Form Fields. Deadline: Can Someone Assist?

Jan 2, 2006

I have a form that pulls data from a table. Basically the form is just a postcard. I have our company name, address, PO Box, city, state and zip in the upper left corner. My fields in the center of the postcard tie back to a table that contains the contact companies name, street address, PO Box, city, state and zip. My question is this: How do you format the contact company, address, PO Box, city, state and zip so that it appears uniform when printed? Some of the contact companies will have a street address but not a PO Box. How can I have the form print so the PO Box does not leave that field blank and pulls up the city, state and zip into that empty space? Also if one company's city is shorter than another how can it be formatted to pull over the state to make it uniform?

Any help on this would be greatly appreciated. I am under heavy deadline to have this form corrected and working by the end of the week.

Thanks in advance,
cnut1

Attempted to add the database but it would not upload for some reason. Will try again tomorrow. I am sure the way I am doing some things are not necessarily the best or easiest way since I am still learning Access. The form I am looking for help on is frmpostcardJanfrt.

View 3 Replies View Related

Modules & VBA :: Calculate Deadline With Workdays And Holidays

Mar 19, 2014

I am trying to get a module set-up that will add a number of workdays (no weekends, no holidays) to a date that is mentioned in a form and put the resulting deadline date in another field on the same form (date or remaining days to deadline would be even better).

Now it gets a little tricky, the module will need to select different amounts of workdays to be added to the date in the form depending on what status is selected (different statusses have different amounts of days).

I'll probably need:
List of holidays
List of days required per status
Start date (to which the days can be added).

Example:

Status = "DQ" which has 2 days to work with.
Start date in form = "21/03/2014".
Result = 25/03/2014 or preferably "2 days remaining".

View 14 Replies View Related

Design Table So That When A Box Is Checked Data Is Transferred To Another Table

Mar 23, 2012

I am designing a database for my organisation. I have done most of it but am stuck on this. Ideally I would like to have a check box (in a table) that when checked a load of data is carried across from that record to a record in another table.

Given that I can't and don;t want to use VB is there anyway that this can be done easily?

View 8 Replies View Related

Help With Table Design

Nov 28, 2005

I am having problems coming up with a Table design and need help.

I am trying to design a table that will have 8 categories, 47 subcategories, and then choices within those categories.

Much like the following (this is only one category example, there will be many):

(Main category) Floors -> (Sub categories) Joist, Carpet, Vinyl Flooring, Wood Laminate -> (Choices for Joist Sub Category) Structure Wood 2X8 Joist, Plywood 2X8 Joist, Structure Wood 2X10 Joist, Plywood 2X10 Joist

This only shows the flow if the main category is "Floors", sub category "Joist", and then the choices under subcategory "Joist". There will be others for the other categories, subcategories, and choices.

Can someone help me or steer me in the right direction in setting up the database table/tables to accomplish this. Oh and BTW, there will be prices attached to each "Choice" under the subcategories.

I hope that this makes sense... any help would be much appreciated.

View 1 Replies View Related

Design Table

Aug 30, 2006

I have 5 tables with the same data (row and columns). How do I make it into a relational table?

View 3 Replies View Related

Table Design

Jan 29, 2008

if i had a table with products and i want to keep a record of what has been chaged or added to this product, whilst keeping the old records how could i set it up in a databse?


the excel spread sheet looks like this



product commments

1 chnged this and that 20/08
1 modifyed component 21/08

2 newest model 3/08

View 1 Replies View Related

Table Design Help

Oct 23, 2004

Hi all, i wonder if anyone can help?

It's a simple question really. I'm currently learning databases and am doing a project, just to show that i understand everthing i've learnt so far. I have to produce a small database.

There's nothing difficult about the project, and its a very basic database, but i was just hoping to ask a small question.

I'm producing a DVD database, to hold details on a collection. My main table holds the majority of the fields, as follows;

lngDVD_ID
strDVDTitle
strYearReleased
lngDiscAmount
dtmFeatureLength
lngCertificationID
ysnBoxset
ysnExtraFeatures
strDirector
lngMovieStudioID
lngCategoryID
curPurchasePrice

The problem came with boxsets. Originally i was just going to have boxsets as one entry, but some contain a few dvd's, each with different certification, etc, and i wouldn't be able to record running length, director, etc.
So i added a ysnBoxset field (just to record whether a dvd was part of a boxset or not) and then made a new table with

lngDVD_ID
strBoxsetName

So now i can record which are part of a boxset, and the name of the boxset they belong to. But.. then i got to the problem of Purchase Price. Obviously i cannot record an individual purchase price for those which belong to a boxset, and i want to be able to record the price of the boxset.

So my question is... is it acceptable to add a curBoxsetPrice field to tblBoxsets, which would allow me to store the price... and then just leave curPurchasePrice as £0.00 for those dvd's in a boxset??? Or is there a better way of doing it? (I know there is, but i'm a novice :( )

Thanks for any help you can give, sorry for the lengthy explanation! :rolleyes:

View 3 Replies View Related

Table Design ??

Mar 14, 2005

Within my db I have a table, tblProjects which currently has 36 fields. Each project will have a fixed set of 12 tasks, each having a begin and end date as well as a yes/no "completed" field. This would add another 36 fields to tblProjects.

Instead, I have created a new table tblTasks which has these 36 fields along with a PK(TaskID) and FK(ProjectID) and is related to tblProjects. I believe tblProjects is already normalized properly with relationships to tblCompanies and tblContacts as well.

I'm not sure if this was neccessary, or should I have just added the task fields to tblProjects. What, if anything, are the advantages of one way over the other? I'll be upsizing to SQL Server, does that make a difference?

I appreciate any advice,

Sup

View 7 Replies View Related

Table Design

Jun 2, 2005

Hi,

Bit of a long one but I require some advise if people can supply it.

I've started creating a DB that is now getting out of hand due to me being inexperienced. The things I want to do now are getting way to complicated. From reading various posts I know that this is all being caused by my database design and while the DB is still young I'm go back to square one. I want your advice on this if you can to ensure 3 weeks from know I'm again not chasing up weird bits of VB code to make it all work.

I basically have a lot of information to hold that interconnects with each other. I'm making up a role profile DB (so we can assign define access rights to a computer system) I have lots of info to collate but the basic stuff is.

Staff Records (Name, business area & ID)
Applications (What computer applications do staff require)
Shared Drives (What access to shared drives and folders do they need)
Shared Mailboxes (what access to shared mailboxes)
Roles (users will be assigned roles to suit their requirements)

Basically what I have at the moment is below.

Roles
Role ID
Role Name
and about 15 other fields that dont really matter for this

Applications
Application ID
Application

Shared Drives
Shared Drive ID
Shared Drive

Shared Mailbox
Mailbox ID
Mailbox

Each role will only have a select number of applications, mailboxes and drives from the overall list. so role 1 may give access to 2 of the 10 applications, 1 out of 5 shared drives and 3 out of 4 mailboxes. Role 2 on the other hand may need 9 out of the 10 applications, 1 out of the 5 shared drives and 1 out of 4 of the shared mailboxes.

I just don't understand how I can create a form from these tables that would display all the different roles with their respective apps, mailboxes and drives they would need.

any advice you can give to help whould be appreciated.

Again sorry for the long post.

View 1 Replies View Related

Table Design

Jun 5, 2005

I am designing a db for our Law office. I want to have tables for different types of Civil Cases-ie Divorces, Deeds, Contracts, Personal Injury, Auto Accident, Slip and Fall, Product Liability, etc. The divorce, Deeds, tables are easy but I am having difficulty deciding on the personal injury tables. Heres my dilemna. Can I get away with one or two Personal Injury tables even though there will be blank data fields. For example, I will need a field for the name of the product in a Producrs Liability field. This field will be blank in all other Personal Injury Cases. I know the rule is you don't do that but my alternative is 15-20 tables for every concievable Personal Injury Case- Auto Accidents, Slip and Falls, Fraud, Prouduct Liability, Accounting, Attorney, Dental and Medical Malpractice, etc. This is in addition to other civil case tables, criminal case tables and federal case tables. Anyone have a suggestion?

View 6 Replies View Related

Table Design Help

Aug 30, 2005

I am not sure if which I should be using as the main entity for my tables. I am creating a database for hourly information on individual employees. Each employee will have the same types of hours to keep track of (weekly, bi-weekly, monthly etc) I naturally thought to treat each employee as the databases own entity and created fields for each type of hours but hit some trouble when trying to pull queries to compare each employees hourly information against each other to see who is being efficient or not. Each employee has the same exact fields but with just different numbers. We track each type of hour by week (Field One: Week 36, Field Two: Aug 28-Sep 03)This is the first time I am creating a database from scratch. All advice greatly appreciated and TIA :confused:

View 10 Replies View Related

Table Design

Oct 7, 2005

I have a table within a database and i was wondering whether or not i should split the table into 2 seperate tables.

The layout of the existing table is to record quotation information ie product codes, cost price, sell price, delivery dates available etc and it also contains fields that allow the user to state if the quote has been authorised or declined, when it was authorised and a number of options to explain the reason the quote wasn't accepted.

QuotationID - Primary Key
EmployeeID - Foreign Key
CustomerID - Foreign Key
EnquiryID - Foreign Key
ProductCode
Quantity
CostPrice
SellPrice
DeliveryDateAvailable
Notes
Authorised - Yes/No field Type
DateAuthorised
Declined - Yes/No field Type
ReasonDeclined
LostPrice - Yes/No field Type
LostStock - Yes/No field Type
LostDelivery - Yes/No field Type
LostCustomerClient - Yes/No field Type
LostNoFeedback - Yes/No field Type

above is the layout of the table, does anyone think that it might be a good idea to split this table into two tables, one table to record the quote information and another to hold the authorisation or decline information??????

View 3 Replies View Related

Table Design Help

Oct 25, 2005

i am creating a database for a local football club. I want to show player information (the main focus of the database), such as, what guardians are responsible for this player, what are the Doctors details for this player, what team does the player play for etc.
I have seperate tables for the Guardian, Doctor and Team information.

I also want to hold Staff details, (Name, address, staff title etc)

My problem is that someone in the staff table, could also be in the guardian table.

Should i combine the Guardian and Staff tables into one table as I dont want to have to enter the data twice for both a staff memger and a guardian

Note:
a player can have more than one guardian
a guardian can be responsible for more than one player.

What is the best way to approach the design of these database tables.

Thanks in advance

Pat

View 4 Replies View Related

Table Design Help..........I Think

Feb 20, 2006

Have a database that I am working on this is constructed to perform Compliance tracking of wellness activity by employees. Have all my tables, queries and a form that has 3 tab controls as well as a subform on one of the tabs.

It is necessary to create a quarterly report card based on 6 wellness cateogories that have specific criteria. I thought I was OK but now I am having difficulty pulling it all together on the report. I now think that it has to do with my table construction and I am looking for advice. If there is someone I could send my DB to who can take a look and give advise or assistance I would greatly appreciate it. Thanks.:confused:

View 6 Replies View Related

Help With Table Design

Aug 2, 2006

Hi,

I'm currently in an internship working solely with databases. I've become really interested in designing databases and I now want to design my own. I was wondering if I explained my table structure then someone could give me their thoughts and ideas for improvement. I have a huge sport trading card collection and I wanted to create a database for it. This way I could run some quick queries to find out how much my collection could be worth, how many cards I have, easily keep track of duplicates. Things like that.. This might seem strange, but I think it would be a good learning experience that would help me utilize many of the features of Access.

My Table Structure:

Ok I have a Company table(Topps, UpperDeck, etc) and they sell many boxsets(which would be another table).. Boxsets have many Cards(which would be my third table)...

Now here is where I get confused. I want have a sports table that would categorize my cards by what sport they are, but I don't know where I could link this. I also have a players table. This table will have a 1:M with Cards because 1 player can have many cards, but couldn't Cards and Players have a 1:1 because 1 card shows one player???

Finally, I want a Price Table that will be linked somewhere, but I've yet to figure out where to link this too.. Have I missed anything???

Your ideas and opinions are greatly appreciated!!!

Thanks!

View 1 Replies View Related

Table Design

Oct 7, 2006

i have a table(patients) with more than 1500 records.this table contains patients information like diagnosis etc.I use cbo boxes in my form to choose info.(i have separate tables to keep this information e.g.table for diagnosis, table for treatment procedures etc.

of course these info are kept in the patients table as text fields.and also i have many query with criteria to select specific records(for example ) parameter value is [Enter diagnosis] and i type for example "cardiac" to get the list of cardiac patients etc.

now , the size has become large . so i want to do somthing to solve this
i designed this when i was very new to access.

how if i want to change the field type from text to number which can look up the required info from other table.

but if i do this , i think that my queries want work .

any advice on this.

i have about ten fields to be changed from text to number.

View 2 Replies View Related

Something Like 3D Design Table?????

Jan 10, 2007

In this database the Tables are:
Materials (Material_ID, Material_Name, etc.)
Users (User_ID, User_Name, Date_modified, Hour, etc.)
Enviromental Values Of Materials (Ev_ID,Cretarion_01, Cretarion_02, etc.)

So i want to build a relation like a 3d axis system like that:
X: Materials
Y: Envirometals Values Of Materials
Z: Users

So for each user may correspond with 1 or all of the materials and for each material many enviromental values(cretarion_01,cretarion_02, etc.)

Namely i want to do a database where a person saves a number of material (1 or all) and for each material a number of Enviromental Values(1 or more).

I make a relation (see attach file):( :confused:

What is your opinion about that?
It would be a broblem if the PK's type is text?

Thanx in advance....

Happy new year:)

View 1 Replies View Related

Table Design

Feb 7, 2007

Being a newbie I have a general table design question which I would be grateful if someone could advise upon.

In Access 2000 I currently have 3 tables for use in a holiday cottage rental system:

tblCustomer (customer details)
name (text)
address (text)
telephone (text)
etc.....
customerID (autonum)


tblreservation (cottage reservation details)
cottage (text) - linked to tblCottage
customer (test) - linked to tblCustomer
start date (date)
number of nights (number)
Adults (number)
Price (currency)
etc.....
ReservationID (autonum)


tblCottage (list of cottages available for rental)
cottage (text)
CottageID (autonum)


I need to add a table structure which defines the price band for each cottage at several times throughout the year, in order to take account of peak holiday periods etc. The price field in the tblReservation table needs to refer to the correct price band based on the cottage and the start date of the reservation.

Any thoughts how best to approach this would be greatly appreciated.

Many thanks

Chris

View 5 Replies View Related

Table Design

May 13, 2007

Hello,

I am looking at creating a database for a charity, to help them maintain there volunteer information.

The database will need to hold information about the charity, volunteers and there roles, language and status.

This is the db design so far.

Branch
id PK - charity number
name *
house *
street1 *
street2
street3
town *
city
postcode *
p_office *
p_land *
p_mobile
fax
email not sure of data type and length
www not sure of data type and length

volunteer
id PK - unique number, auto number
vol_name *
f_name *
s_name *
house *
street1 *
street2
street3
town *
city
postcode *
p_home *
p_work
p_mobile
email
last_change date/time, when record last updated

vol_link_lan
vid FK, PK
lid FK, PK
level
qua

language
id PK, Auto
name *

vol_link_rol
id PK,
vid FK
rid FK
sdate *
edate *

role
id PK, auto
name *
description

vol_link_sta
id PK,
vid FK
sid FK
sdate *
edate *

status
id PK, auto
name *
description

I am not sure if the vol_link_rol and vol_link_sta are correct, I have created a PK to ensure there is a record of the volunteer and the status and the same for the roles table.

comments please.

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved