1 job, multiple customers. How do I make an accurate table?

My company is a supplier, so we submit our bid numbers to multiple 
contractors for a single job. There are about 70 jobs a month.

Example. Job: Hostpital... Customers... apple, orange, and kiwi

How can I accuratly input this information (multiple customers for 1 job) 
per job without messing up all my other jobs that I bid for that month?

I will gladly email my database
0
Utf
11/21/2007 4:50:01 PM
access 16762 articles. 3 followers. Follow

2 Replies
427 Views

Similar Articles

[PageSpeed] 10

Your target paradigm is a many-to-many relationship.  To model it
requires a junction table which will have the Primary Keys from
tblCustomer and tblJob as Foreign Keys.  You might name the new table
~tblJobsCustomers.  There will be a record in that table for every
intersection of a job and a customer.

HTH
-- 
-Larry-
--

"HoganD87" <HoganD87@discussions.microsoft.com> wrote in message
news:7C50C869-32AF-4AAF-931B-0A10DB9E94F0@microsoft.com...
> My company is a supplier, so we submit our bid numbers to multiple
> contractors for a single job. There are about 70 jobs a month.
>
> Example. Job: Hostpital... Customers... apple, orange, and kiwi
>
> How can I accuratly input this information (multiple customers for 1
job)
> per job without messing up all my other jobs that I bid for that
month?
>
> I will gladly email my database


0
Larry
11/21/2007 5:15:24 PM
Or better still, call it tblBids - and include the bid details.

-Andrew-
0
14esc
11/22/2007 2:44:16 AM
Reply:

Similar Artilces:

Disaster Recovery for CRM 1.2
Does anyone have any documentation on the steps to backing up CRM 1.2? We want to make sure we are backing CRM 1.2 up correctly if the server should go down. We were unable to find any documentation on Microsofts website for a step by step backup solution. Right now we are just backing the CRM databases using the scheduler in SQL; is this ALL that is required and if so do we backup ALL of the databases or just certain ones? The owners of the company want to make sure we can restore ALL of the data if needed. -- Thank You, Troy Hi Troy Microsoft have included details of backing...

Printing Multiple Receipts at a Time From Journal
Hey guys, Is there a way to print multiple journaled receipts at a time? Say all receipts for a batch or by date or other criteria? Thanks Tom, Not that I've seen. -- = Get Secure! - www.microsoft.com/security You must be using Outlook Express or some other type of newsgroup reader to see and download the file attachment. If you are not using a reader, follow the link below to setup Outlook Express. Click on "Open with newsreader" under the MS Retail Management System on the right. http://tinyurl.com/75bgz ========== "Tom Bombadill" <Genius_pos...

How do I make a 'box and whisker plot' graph in Microsoft Excel?
I am in Year 12 and am doing a stats assignment. The project states that i MUST insert a box and whisker plot for some data, but i don't know how to do this. Does anybody know? Hi, Here are some sites on the topic of stats charting not just box and whisker. http://peltiertech.com/Excel/Charts/statscharts.html http://www.processtrends.com/toc_statistical_charts.htm http://tushar-mehta.com/publish_train/data_analysis/16.htm http://people.stfx.ca/bliengme/ExcelTips.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Year 12 student who needs help" &...

Outlook 2003 forgets contacts after 1 day
Outlook 2003 is remembering contacts for a day and then automatically deleting them. I have spent the last hour searching and can't find the right setting to stop this from happening. Has anyone got any advice? Outlook does not automatically save Contacts ever. To what feature are you referring? Autocompletion? -- Russ Valentine "slycbod" <slycbod@discussions.microsoft.com> wrote in message news:36DBB238-7462-452F-85EB-15258BCD8B05@microsoft.com... > Outlook 2003 is remembering contacts for a day and then automatically > deleting them. I have spent th...

How do I make hyperlink target scroll to the top-left of spreadshe
I can't remember the setting to make Excel automatically scroll my hyperlinked cell to the top-left. For example, if my hyperlink is in cell A1 and the hyperlink destination is cell Z30, when you click the hyperlink in A1 the cell Z30 is now displayed in the top-left of the spreadsheet. It seems like there was a checkbox in the Options dialog box, but now I can't find it. I did this awhile ago, but forgot to write down the information. Hi Lori Tools>Options On the Transition tab Transition navigations keys -- Regards Ron de Bruin http://www.rondebruin.nl "Lori W....

Multiple Outlook #2
I imported an Outlook 2000 pst file into Outlook 2003. Now when I open Outlook my Personal Folders appears 4 times in the left hand "All Mail Folders" When I close Outlook it gives me an error and msvbvm60.dll is mentioned. Any help on how to correct this issue would be greatly appreciated. Mick ...

Ho to make one field required based on critera of another field?
I'm creating a form and need to make the "comments" field required if the "code" field is =>20. I appreciate suggestions! Deadline Monster is lurking! User enters the job processing endcode value (numeric) into the "code" field. If the endcode is =>20, comments are required. (P.S. I don't know VB) Thanks! Star You would put your validation code in the Form's BeforeUpdate event. If Me.EndCode >19 Then If Len(Me.Comments & "") = 0 Then MsgBox "Comments are required" Cancel = True End If End If ...

Convert single colum/multiple rows to multiple colums.
Hi, I have a .dat file when opened with Excel it has 1 column and 7 rows per entry. I would like to delete some rows and convert the rest to something like. Any chance this can be done. It's quite large. 51,793 rows. TIA Jeff Col 1 Col 2 Col 3 Name Date Lenny Kravitz - 2000 - Greatest Hits -- Table: {2} { "music" "Name", "06/04/2008", "Lenny Kravitz - 2000 - Greatest Hits", }, --Table: {3} etc. etc. ...

making an equation in access
Hi, I would like to create a field that works out a formula based on other fields. i.e field z=field4, when field 1<field 2 - field 3 etc. Yes, it may be a silly question but I am only new to this....Thanks, Dani. Dani, recommend against creating a "field" in a table and storing this value. One of the generally accepted rules of relational database development is not to store a "computed" (any value that is based on the value of other fields in your database) value in the table. It is a waste of database space, and will eventually result in bad data (...

Printing Multiple Copies #4
Hi all - I am using Vista Business and Publisher 2007 from the Office 2007 Small Business package. No matter what type of publication or template I use I can only print single copies. Most recently I tried to print 30 copies of a single page flyer and had to do it a single copy at a time. If I go to File|Print and set the number of copies to 30, I still get a single copy only. Does anyone have any thoughts? Thanks -- Andrew Aitchison (amhsn@nospam.sympatico.ca) Is your printer driver current? What is the default in the printing preferences in the control panel printer folder? ...

Pivot Table Question #15
Hey all, Love pivot tables but i have a question, the table is set up as so Month Pallet# BoxesPur BoxesSold Price Frt Gross Net Jan 1 5 1.0 ..3 Formula Formula 2 5 2.0 .5 3 10 3 .15 Jan Total 10 10 6.0 ..95 So, the problem is in the Jan Total row, is there a way...

data value in Form field if no table entry
I have a form with a field which pulls through and concentenates 2 fields called [ContactFirstname] and [ContactLastName]from my table There are however some customers for whom I do not have names and therefore instead I would like Sir/Madam to appear in the field in the form I think I have seen this done somewhere using ELSE? but can't find it Any help/ideas gratefully received Perhaps something like this: Nz(Trim([ContactFirstname] & " " + [ContactLastName]), "Sir/Madam") -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access use...

Article published by Microsoft reg. 'Event' custom entity
Recently, I found a great article published by Microsoft that contains a sample code on how to create a custom entity, event. I thought that I bookmarked it but cannot find it. Has anyone seen it and can provide a hyperlink? I will really appreciate it. http://msdn2.microsoft.com/en-us/library/aa682866.aspx you'll probably find it in the above link "mkatsev" wrote: > Recently, I found a great article published by Microsoft that contains a > sample code on how to create a custom entity, event. I thought that I > bookmarked it but cannot find it. Has anyone seen...

multiple revieve of emails
I recieve multiple copys of emails in outlook. In some cases I get 100 copys of the exact same message, in other cases it is ok, then others many times Only one message on server Jim <anonymous@discussions.microsoft.com> wrote: > I recieve multiple copys of emails in outlook. In some > cases I get 100 copys of the exact same message, in other > cases it is ok, then others many times Only one message on > server Usually caused by 1) Send/receive interval too small or 2) server timeout value too small or 3) rules that don't contain the "stop processing more rules...

Multiple Account Download from One Financial Instituition
Hi, I have at one brokerage mutliple accounts (individual, joint, 401K, roll-over etc). In Money they are all separate accounts. When I connect with the brokerage I am only able to connect to one type of account (in this case retirement). How can I download multiple accounts from a brokerage (when not all have the same URL). Please email me your reply. Thanks Sandeep ...

Enter multiple cash receipt payment methods in Cashbook/BM.
When entering a receipt into cashbook/bank management, there is sometimes a need to receipt the amount as more than one payment type - e.g. cash and cheque. This process is accommodated well in SOP. It would be useful to have this type of procedure included in Bank Management. This is a user request from Pan Pac Forest Products. ...

Count Unique Items with Multiple Criteria
I am trying to get a list of how many lots a particular car model is on. For example, say we have a spreadsheet that looks like: Model License Lot Ford xjd-394 1 Chevy gwg-394 2 Ford sdf-333 1 Ford lkj-111 3 Toyota skd-333 4 Toyota shk-584 4 I am loking for a way to get data that says how many unique lots each car is on, so for example: Ford: 2 Chevy: 1 Toyota: 1 I was trying to do this with Pivot tables and the count functionality, but it isn't quite getting me the results I want. I can get the results with a pivot table ...

How can I cut data out of HTML table, into msExcel and just take the data & columns? (but NOT the formatting & URLs!)
Hi This is driving me ABSOLUTELY NUTS! How can I keep the rows & columns of data that I am copying and pasting off a website (my own in this case!), into a spreadsheet... WITHOUT taking all the data formatting? If I paste out of Ms IE v6 into Ms Excel (2003), it does at least keep the columns (something that doesnt happen if I paste out of FireFox, fwiw). But it pastes with all the formatting & URLs etc - which I DONT WANT! OK, I can save as .CSV, close, 2 warnings, and re-open but when done REPEATEDLY this is a damned nuicance! Any suggestions? Ship Shiperton Henethe ship w...

Retrieving sorted data from same table.
Hi All, I am working on a table (mentioned below) I am looking for a query which can get me the data according to the =93id=94 column with respect to speed. The condition is that I have to get three consecutive entries which have speed > 60 Below is the sample table with data on which I have to retrieve the data on above condition. The output i need can be as given below DVXC002 12/10/09 0:12 96 DVXC002 12/10/09 18:40 89 DVXC002 12/10/09 19:43 65 DVXC005 12/10/09 11:56 69 DVXC005 12/10/09 15:26 62 DVXC005 12/10/09 17:35 85 Need your help urgently....Thanks in advan...

Collecting multiple feeds
Folks, I am subscribed to about 30 radio podcast feeds. When I refresh them on any given day, there will be five or six that refresh, and on Friday, there are about twelve. For each one, I click the URL in the feed, which opens the site for that radio program. Then I right-click the link to the podcast and select Save Target As... As it all goes onto the same directory on an MP3 player, I don't have to select it each time, but when the download frame comes up, I have to click the Save button. As most of these programs come from the BBC site, which only allows two si...

help needed on multiple option buttons
Hi, I am trying to use option buttons in a few different locations in Excel. In one cell i want three options and three different buttons. In another locations, two options with their own two buttons. However, the 5 buttons act as 5 linked options, so i can only have one or another button selected at a time. I would like one of the first three selected and one of the next two and so on. Can anybody help me work out how to resolve this. Thanks, If you used optionbuttons from the Forms toolbar, put a nice groupbox (also from the forms toolbar) around each group. If you use optionbuttons ...

Mastering Great Plains Tables
Greetings, Does anyone have or know where I can acquire a detailed document detailing every single Great Plains table? I've used the data dictionary on and off over the years and have familiarity with a decent number of the important tables that are critical to my work, but is there something a little more detailed so that I can get at least a cursory understanding of *all* the tables? I'm thinking of creating a flash card for each table and on the back writing a brief sysnopsis of what it's used for, then regularly quizing myself. Failing anything else, I'll probably use th...

Pivot table Data field question
I create a pivot table from three columns of data, using the Wizard.In the Layout dialogue, I drag one of my fields to the Rows; I drag anther field to the Columns. I need to drag a third field to the Data area. There's no conflict there, each Data cell of the resulting matrix would be unique. Excel doesn't let me do this. It insists on using a calculation, e.g. Sum of [field3], Count of [field3], etc. How do I convince Excel to insert just the value of Field3 in the Data? -- Regards Gershon Shamay The field you drag to the data area will always be summarized. However, if the v...

how to repeat print single tile of multiple tile poster?
in publisher one tile of multiple tile poster failed to print (ran out of ink). how do I print only the tile that missing? Other than complete (20 sheet) print run. There is no easy way of doing this. Take a look at print preview to determine what tile you need to print. Create rectangles around the areas you don't want to print, fill with white, no line. Keep checking print preview to be sure you are covering the correct tiles. You will end up printing 20 pages, but only one will use ink. -- Mary Sauer http://msauer.mvps.org/ "billyb." <billyb.@discus...

Combine multiple columns into one, automatically?
I'm trying to create a chart that will automatically combine into one column what are now several columns when displayed in an ordinary column chart. The columns I want to combine all have the same value on the Y-axis, but are shown (in an ordinary chart) as separate columns because they have different values along the X-axis. Is there any way to create a chart that will automatically add together the X-axis values and then display the results in a single column? Or, is this not really a "charting" problem, but instead a problem that requires me to recalculate my data bef...