Table Design Issue

I  have a database the has a Parts Table and a Vendors Table. what needs to 
happen is i need a form that will allow someon to view all the information 
about that parts itself and the vendors that  supply  the part but  every 
part is available by  all 5 vendors for different  cost, and  i need to 
construct tables that when part information is undated or deleted it will 
reflect across the board and on the form itself be able to see the vendor 
name and the part information for that vendor.

what type of relationships will be involved here
0
Utf
10/5/2007 2:59:00 AM
access.forms 6864 articles. 2 followers. Follow

1 Replies
761 Views

Similar Articles

[PageSpeed] 45

Answered in tablesdbdesign.
0
Allen
10/5/2007 3:15:18 AM
Reply:

Similar Artilces:

Creating a registration table list based on an existing table
Hi, I have an access database that contains transactional tables which I cannot alter. There is a table called invoice. This has ClientId, ClientName and ItemNumber. The ClientID is a ten digit number while the ClientName is a business name. There are no extra fields that I can use in it. I want to create a form that will enable the staff to keep track of registration. A registration is initiated when an invoice on a client is created with the itemnumber being College. Right now, people are keeping track of attendees using a spreadsheet but I want to create a table that contain...

Query from 3 tables
I have three tables that I want to put in query. But this is what I need: Articles Stores MinimumQTY ----------- ---------- --------------------- ArticleID StoreID ArticleID ArticleName StoreName StoreID ArticlePrice MinQTY OptimalQTY What I would like is to have a query that shows all recors from Articles, and for each article to show all Stores and for each StoreID to show records in MinimumQTY...

Smart list source tables
I'm using smartlist builder to create custom smartlists. It sure would be easier if I knew what tables teh "canned" smartlists used or could pull up a * canned smartlist and edit it as my own including adding additional tables to join. With soooo many tables in GP It is not a simple task to use the right one instead of the "close but no cigar" table. Any table indexing would help. Hi Vacations If you go on customer source you can downlaod some smartlists, that can be imported with smartlist builder. They are listed for version 8 of GP but they will work on 9 a...

Pivot table chart problem
Hello! Can somebody help me to solve one insignificant problem related to pivot table charts. I want to have grand totals displayed in the chart, which was created using a pivot table. I tried many different ways, but couldn't succeed. Is it impossible? If so, are there any other ways to display the totals in the chart. I really apreciate your help. Thank you in advance. --- Message posted from http://www.ExcelForum.com/ I don't know of a way to include the grand total in a PivotChart. You can create a normal chart, based on the pivot table, and include the totals in that. On Jo...

setting caption for table
Hello there I have access ADP project. In the project I have forms bound to table and present it as datasheet view. Can I change the caption of the table which present? and not the name of the field? ...

Show Pages of Pivot Tables
Excel 2000 had an option called Show Pages for Pivot Tables which created a copy of the pivot table for each item in the Page category. Ths option is no longer available (or not appearantly available). Is anyone aware of how to replicate this option in excel 2003? On the PivotTable toolbar, select PivotTable> Show Pages Denis wrote: > Excel 2000 had an option called Show Pages for Pivot Tables which created a > copy of the pivot table for each item in the Page category. Ths option is no > longer available (or not appearantly available). Is anyone aware of how to > r...

issue with XML and Schema namespace
Hi I am having a hard time with validation of my XML file with given schema. Here are the files: roboerrorlog.xsd <robomss:schema xmlns:robomss="http://www.w3.org/2001/XMLSchema" xmlns="robomss" elementFormDefault="qualified" targetNamespace="robomss"> <robomss:element name="roboErrorLog" type="errorLogType"/> <robomss:complexType name="errorLogType"> <robomss:sequence maxOccurs="unbounded"> <robomss:element name="error" type="errorType"/&...

Exchange Domain issue
Hi, I have a domain in windows 2003 named "abc.com" which has a AD and DNS itself inside my company,all the users are logging to this domain,but my email and wesite is as "xyz.com" which is outside our network.Now we are planning to install a new server with exhange 2003 inside our network,can anybody tell what is the best way to install exchange. I planned to install the exchange as member server of the domain abc.com as mail.abc.com but when i told my ISP to route the mx record to my mail server inside the company ,they told that our server configuration is not correct. ...

Table relationships and lookups
Hi guys, I may be a little over my head, I've had some experience in creating simple access db's. however this one will be extremely complicated as far as I can tell. Some backround info - i've got an excel spreadsheet currently that i would like to convert to Access. The spreadsheet does multiple lookups and calucations. This is for a Soccer club that i run to maintain roster information, dollars, scheduling and stats. I'm currently working on the scheduling pience. Here's what I have so far. tables. Club - Lists the teams in the club, home field name and ...

tables design and forms for setting up scheduling/accompl of clean
I am trying to set up tables, and forms for easy use for Maintenance dept. for the cleaning of areas of the factory. There is a set required schedule for each location in the plant. some areas are daily some weekly, some twice a week, etc. When they click on the location( on the Map of the plant form) I would like it take them to what is scheduled for that location for that day - they would also need to check off what has been completed for that day. Not sure on how to set up tables and form. Some fields I need are locationid, job#, date, freq? , job desc. etc. I would also like the o...

Creating custom tables in Dex
Hi, Is there an easier way to create custom tables through Dex than creating datatypes, fields, and then the table? I have a table with close to 300 fields, and this seems quite tedious. Thanks in advance for any help. Tom You can re-use any of the datatypes and fields in the Dynamics dictionary, assuming that you are writing an integrating product. If writing a standalone product you will need to create all the datatypes and fields needed. You can also created on-the-fly while creating the table definition rather than creating them all beforehand. Hope this helps. David Musgrav...

XSLT problem -- namespace issue?
Here's a sample XML file (created by saving a dataset): <?xml version "1.0" standalone="yes"?> <dsData xmlns="http://tempuri.org/DataSchema.xsd"> <Configuration> </Configuration> <Data> <ID>0</ID> <Title>Test #1</Title> </Data> <Data> <ID>1</ID> <Title>Test #2</Title> </Data> </dsData> And my XSLT style sheet: <xsl:stylesheet xmls:xsl="htt...

Outlook Vcard security issue
Exchange 5.5, sp4 using Outlook2000 - users with Vcards and discovering that if the receipient opens the vcard and goes to the activities tab, they can view the senders inbox emails. This is internal users only and what makes matters worse, it is not all of them. They can send the card to me and I can't see the inbox, but they can send to the person sitting next to them and they can. I've checked all mailbox permissions and they have not granted these people access. I'm not sure how to stop or even troubleshoot this. I feel if it was an Exchange mailbox permission issue, all ...

Evaluate String for Value from Table
I have a table [tbl_dc_dx] that contains a field for Primary Diagnosis but only a semi-colon delimited list of Secondary Diagnoses. The list is variable in length and the[sec_diag] codes are in no particular order. [tbl_dc_dx] sample data: Account sec_diag 1 5990;2851;6262;2809;6202 2 6262;2800;4019;2808;2469 3 2851;9100;9219;E8889;E8497 4 4111;2859;4019; 5 5855;42822;2724 6 25000;4019;4580;2801 A list of applicable diagnosis codes is available in a table called [tbl_dx_codes]. [tbl_dx_codes] sample data: diag_cd diag_desc 2800 280.0-CHR BLOOD LOSS ANEMIA 2801 280.1-IR...

Customization CRM Web References Issue
When I add a new Web References for my project using http://<mylocalhost>/mscrmservices/2006/CrmService.asmx, I get an error message as below: c:\inetpub\wwwroot\MedSculpt_Don_Cust\Web References\CRMSERVICE\Reference.map(1): Custom tool error: Unable to import WebService/Schema. Unable to import binding 'CrmServiceSoap' from namespace 'http://schemas.microsoft.com/crm/2006/WebServices'. Unable to import operation 'Execute'. Schema with targetNamespace='http://schemas.microsoft.com/crm/2006/WebServices' has invalid syntax. The global element '...

Payment Terms issue!
Hi, I am facing a problem with Payment terms. I create a quote with terms discount applied to it. Then transfer the quote partially to order & partially to invoice. Now terms discounts are applied to the invoice that gets created but not to the order. In the SOP_HDR_WORK table I see the Payment terms ID for the order but no discount is applied. Now even when I modify this order the terms discount is not applied. Is this the system behaviour or am I missing something here? Thanks & Regards, Sup ...

Piviot Tables
I have a few piviot tables that work off a large data table. one of the fields I use is "Acct #s" I have about 200 different acct #s. I one piviot table I only need to show 2. Is there a way to unselect (uncheck) all the account #s in the drop down so I can go back and just check the two I need. Thanks in Advance There are sample macros here that you can use to show or hide the items in a field: Excel -- Pivot Tables -- Show and Hide Items http://www.contextures.com/xlPivot03.html TO wrote: > I have a few piviot tables that work off a large data > table. &...

CRM integration for GP: reinstall issue
When I uninstall and reinstall CRM integration for GP, I get a message that "the user specified does not have all the required CRM privileges." The Integration User in CRM is a system administrator, and the domain\integrationuser account is a member of the domain admins group. What other privileges should the account have? Did I uninstall incorrectly? TIA, Pete. Is the domain\integrationuser account a CRM administrator? "Pete Grare" wrote: > When I uninstall and reinstall CRM integration for GP, I get a message that > "the user specified does not hav...

Cached Mode and GAL Issues
Hello All: Exchange 2003 SP2 with Outlook 2003 Clients. Running clients in cached mode and changes to GAL are not upfdating to clients. I have followed some of the KB articles and "fixes" found in other posts to no avail. Last tried changing times when Exchange rebuild OAB, deleted .ost from client and downloaded "new" OAB....still same thing. The only time I can get an updated copy of GAL is to switch off Cached Mode which then kills spam filtering. Any suggestions? Thanks "Joe" <none> wrote: >Exchange 2003 SP2 with Outlook 2003 Clients. Run...

Excel 2007
In Excel 2003, if I had a pivot table open, I could go to a new workshhet, create a new pivot table and one of the choices for the source data would be another pivot table in this workbook. This would create a new pivot table using the same pivot table cache. I can't seem to find the equivalent functionality in Excel 2007. Can this still be done? Tom I believe this is now deprecated, sorry -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS web: www.nickhodge.co.uk UK Excel User Conference In Cambridge November 28th - December 1st 200...

String Table #2
I am getting ready to paste hundreds of string table entries into my .rc file. Could I get some advice on how to proceed with: STRINGTABLE DISCARDABLE BEGIN . . . END ? I can't say I truly understand what STRINGTABLE DISCARDABLE does. "Steve Russell" <srussell@removethisinnernet.net> wrote in message news:eAchxUVnFHA.2472@tk2msftngp13.phx.gbl... >I am getting ready to paste hundreds of string table entries into my .rc >file. Could I get some advice on how to proceed with: > > STRINGTABLE DISCARDABLE > BEGIN > . . . > END > ? > > ...

Pivot Tables #7
Before i post my question am I on the correct board to answer my question? I've a question on pivot tables and want to make sure I'm in the correct place. Thanks Here is my question. I have a pivot table that does what I want it to except the category field that is a column field shows two different figures and I would like the final column to calculate the percentage of one against the other. For example extract of pivot table is like this: Calls answered Calls resolved 100 5...

how MFC uses hash table to cache message
hi, i want to find out how MFC uses hash table to cache message, then i read the CWnd::OnWndMsg. and the following: const AFX_MSGMAP* pMessageMap; pMessageMap = GetMessageMap(); UINT iHash; iHash = (LOWORD((DWORD_PTR)pMessageMap) ^ message) & (iHashMax-1); AfxLockGlobals(CRIT_WINMSGCACHE); AFX_MSG_CACHE* pMsgCache; pMsgCache = &_afxMsgCache[iHash]; "(LOWORD((DWORD_PTR)pMessageMap) ^ message) & (iHashMax-1)" is used to generate index. but why "xor" pMessageMap and message? is it to avoid collision somehow? i don't get it. thanks, Ian ...

Pivot Table
I have a pivot table that is doing something strange. When I double click a data point in the table, to bring through on a new spreadsheet the relevant data to to that clicked through data point, all of the numbers (in every column which contains numbers) on the new worksheet are formatted as dollars, even though on the original worksheet containing the data, those numbers are not formatted as dollars, but rather formatted as general. The data in the pivot table are not formatted as dollars. The source data are not formatted as dollars (except for just one column). Why would the click through...

OLE Issues
In Office Excel 2003, when I open a New worksheet, in the Task Pane under Template when I click on 'Templates on Office Online' I never get connected and have to close Excel after getting a msg 'Microsoft Excel is waiting for another application to complete an OLE action.' Suggestions? ...