[AccessD] Set up tables - Please Help

DWUTKA at marlow.com DWUTKA at marlow.com
Tue Mar 16 13:59:28 CST 2004


I think I really need to take a look at what you are trying to do.

Can you send it to me offlist?  I won't have a chance to look at it until
later this week, or on the weekend.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
Hollis,Virginia
Sent: Tuesday, March 16, 2004 6:28 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Set up tables - Please Help


This is all taken from a hard copy of the current request form. The buyer
completes the vendor request form with the vendor information. The form is
used to add the new vendor information into    a main database.

The form provides the vendors name, billing information, type of business,
etc. It does not list any items the company will buy from this vendor. Once
the vendor information is added, then the company will issue POs, contracts
to the new vendor (not part of this database).

They just want to track the requests from the buyers.

The form contains a lot of information about the vendor. When I create all
the tables and join them to create a form for entering the information, it
either comes up blank (no records) or I can't add any new records, one try
it kept knocking my query out - I think because it was too long.

Virginia

-----Original Message-----
From: DWUTKA at marlow.com [mailto:DWUTKA at marlow.com]
Sent: Monday, March 15, 2004 3:45 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Set up tables - Please Help


Virginia, I think you are confusing Vendor with Purchase Order.  A Vendor is
just a peice of a Purchase Order, not the other way around.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
Hollis,Virginia
Sent: Saturday, March 13, 2004 10:46 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Set up tables - Please Help


tbl_Vendor contains all the data for the vendor; address, company name, etc.

tbl_VendorMain could really be named tbl_RequestMain. tbl_VendorMain is
where I thought I would store the combination of the data - VendorID,
ContactID, BuyerID, RequestorID, DateRequested.

-----Original Message-----
From: Susan Harkins [mailto:ssharkins at bellsouth.net]
Sent: Saturday, March 13, 2004 10:38 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Set up tables - Please Help


What's the difference between tbl_Vendor and tbl_VendorMain?

Susan H. 

I have one table for each - tbl_Buyer, tbl_Contacts, tbl_Requestor,
tbl_TypeBusiness, tbl_Vendor, tbl_VendorMain, tbl_Accounts.

Tables buyer, vendor contacts, requestor store just the typical name, phone
number, etc.


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list