Results 1 to 6 of 6
  1. #1
    arctushar@yahoo.com is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    Sep 2010
    Posts
    9

    how to creat purchase order

    Hello I want to make an access file for purchase order. feature need are as below.

    1.There will be two table
    A. Item which should have below fields

    1. Item Code
    2. Item Description



    B. Purchase Order which should have below fields

    1. Item Code
    2. Item Description
    3. Date
    4. Purchase order number
    Now I want that someone will search from table item & field description. Say search result give 05 rows. Every row should contain a button. After clicking the button a purchase form will open related to search result and table purchase order.
    Now please help me.

  2. #2
    Join Date
    May 2010
    Posts
    339
    Quote Originally Posted by arctushar@yahoo.com View Post
    Hello I want to make an access file for purchase order. feature need are as below.

    1.There will be two table
    A. Item which should have below fields
    1. Item Code
    2. Item Description
    B. Purchase Order which should have below fields
    1. Item Code
    2. Item Description
    3. Date
    4. Purchase order number
    Now I want that someone will search from table item & field description. Say search result give 05 rows. Every row should contain a button. After clicking the button a purchase form will open related to search result and table purchase order.
    Now please help me.
    Hi arctushar,
    You don't need the duplicates in table B. Also a Purchase order database will have a few more fields then you have listed, for example:

    PurchaseOrderID
    PONo
    PODate
    ShipTo
    BillTo
    Vendor
    OrderQuantity
    Unit
    Vendor
    PartNo
    ItemDescription
    UnitPrice
    Tax
    Total
    ExtPriceWithoutTax
    MoreFields

  3. #3
    arctushar@yahoo.com is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    Sep 2010
    Posts
    9

    thank u

    thank u Access_Blaster.
    then how can I made such database.

  4. #4
    Join Date
    May 2010
    Posts
    339
    Here is a very basic table structure with relationships, to view the relationships goto tools then relationships.

  5. #5
    arctushar@yahoo.com is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    Sep 2010
    Posts
    9
    thank u. it help me. No i think I can go further

  6. #6
    Join Date
    May 2010
    Posts
    339
    Your welcome we look forward to your new threads

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Purchase Order Preview Problems
    By jordanturner in forum Forms
    Replies: 5
    Last Post: 10-03-2010, 10:10 AM
  2. Northwind Purchase Order Number
    By jpl85716 in forum Access
    Replies: 3
    Last Post: 09-29-2010, 12:53 PM
  3. Help With Purchase Order Form
    By SpeedyApocalypse in forum Forms
    Replies: 29
    Last Post: 04-09-2010, 07:06 PM
  4. Replies: 0
    Last Post: 12-11-2006, 04:55 PM
  5. inport data into invoice from Purchase order database
    By Wrangler in forum Import/Export Data
    Replies: 2
    Last Post: 10-30-2006, 12:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums