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 ...
3rd October 2008, 12:02 PM #1
- Rep Power
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?
IDG Tech News
3rd October 2008, 12:36 PM #2
- Rep Power
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.
By LozWesson in forum Group Project
Last Post: 11th July 2012, 04:33 PM
By Pyroman in forum How do you do....it?
Last Post: 2nd May 2008, 04:19 PM
By Neville in forum Coding
Last Post: 25th April 2008, 10:33 AM
By Uraken in forum Coding
Last Post: 11th October 2007, 12:19 PM
By Jobos in forum Web Development
Last Post: 22nd May 2007, 10:49 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)