Prev: Access Database
Next: 怎樣downPowerPoint?
From: Deeds37 on 18 Nov 2009 15:26
I have designed a table and in one field of the table I have used 'look up
wizard' to make a relationship with another table in the database. When I
open the table in datasheet view and click on the field with the 'Look up
relationship' it pulls information from the first column only, not the
second. The relationship of the tables are right, not sure why it is pulling
information from one column only. I would like it to pull from both columns
as the row information is related.
From: Duane Hookom on 18 Nov 2009 17:28
IMO, you should never ever use lookup fields in table designs.
http://www.mvps.org/access/lookupfields.htm.

You should be using forms for all user interaction with your data. Forms can
use combo boxes to display the related values.

--
Duane Hookom
Microsoft Access MVP


"Deeds37" wrote:

> I have designed a table and in one field of the table I have used 'look up
> wizard' to make a relationship with another table in the database. When I
> open the table in datasheet view and click on the field with the 'Look up
> relationship' it pulls information from the first column only, not the
> second. The relationship of the tables are right, not sure why it is pulling
> information from one column only. I would like it to pull from both columns
> as the row information is related.
 | 
Pages: 1
Prev: Access Database
Next: 怎樣downPowerPoint?