Previous Thread

8/16/2006 11:24:18 AM    Sample file for Customers, Orders, Payments etc
Hello all 
 
I am trying to design a software in MS Access for my own use regarding 
 
Customers, Orders & payments. I need a sample file to refine my knowledge. If 
 
anyone can direct me I will be grateful. 
 
Best regards, 
 
isons 
 
-- 
 
Message posted via AccessMonster.com 
 
http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200608/1



8/17/2006 11:59:33 AM    RE: Sample file for Customers, Orders, Payments etc
Hi jmonty, 
 
Many thanks for your reply. 
 
I have downloaded this template and found very useful. I want following: 
 
1-  I want to change the name of field ProductID to PRODUCT_NO to the 
 
products table as I get 
 
raw data from a source and want to use that data in my database. Fields 
 
will be PRODUCT_NO, 
 
PRO_DESCRI, RATE, PACK_QTY etc 
 
2-  ProductID field is autonumber whereas I want to change it to TEXT 
 
3-  I also want to set Product_No as lookup field in ORDERS DETAILS Table. In 
 
my data entry form I 
 
have to enter Product_No only and its corresponding product description 
 
automatically fill in 
 
from Products table. 
 
Please help. 
 
Best regards, 
 
isons 
 
jmonty wrote: 
 
-- 
 
Message posted via http://www.accessmonster.com