+ Post New Thread
Results 1 to 2 of 2
Coding Thread, Using one field in an access database to populate other fields in Coding and Web Development; I'm having trouble working out in my head how to do this. Basically I have an order/invoice table where an ...
  1. #1

    Join Date
    Jul 2007
    Location
    Middle-Wales
    Posts
    368
    Thank Post
    2
    Thanked 4 Times in 4 Posts
    Rep Power
    15

    Using one field in an access database to populate other fields

    I'm having trouble working out in my head how to do this. Basically I have an order/invoice table where an ItemID from an items table is selected from a lookup, what I want to happen is that the item description and price fields are populated from the same items table so I can calculate totals etc. Any Ideas?

  2. #2

    Join Date
    Jul 2007
    Location
    Middle-Wales
    Posts
    368
    Thank Post
    2
    Thanked 4 Times in 4 Posts
    Rep Power
    15
    Fixed it now, apparently you can use [comboboxname].[columns](2) (where 2 is the zero-indexed number of the column that has the data you want in it) to pull data out of a lookup field's combo box.

SHARE:
+ Post New Thread

Similar Threads

  1. Help with Access Database
    By LozWesson in forum Group Project
    Replies: 7
    Last Post: 11th July 2012, 03:33 PM
  2. Microsoft Access Help! Date Field
    By Pyroman in forum How do you do....it?
    Replies: 1
    Last Post: 2nd May 2008, 03:19 PM
  3. Access Database for Assets.
    By Neville in forum Coding
    Replies: 3
    Last Post: 25th April 2008, 09:33 AM
  4. access database
    By Uraken in forum Coding
    Replies: 0
    Last Post: 11th October 2007, 11:19 AM
  5. Reading an Access database with .Net 2.0
    By Jobos in forum Web Development
    Replies: 2
    Last Post: 22nd May 2007, 09:49 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •