Use a single row in another table for a query

[djdaveg]

I am wondering if it possible to refer to a row of data in access for a query, if I want to find a row by ID then use the next field in that row for a query without access using whole column, is this possible.

[Echidna]

Hi Dave,

in the query designer.
Open the tables you wish to display data from.

if no relationship exists between the two tables, you can create one by dragging the ID column from Table one over to the corresponding column in table two (establishing a relationship),

The columns selected from table two will display the data where the ID is equal to Table One.

hope this helps, and is not too vague...

Cheers

Leon

[djdaveg]

Hi, thanks for your reply, however the ID numbers in the two tabels don't match, I have a database in one and a few towns and postcodes in the other, I need to reference a town and then its postcode without access using the whole column in the table and just using the one that the first part of the query has matched

[Echidna]

does the main table have any reference to the data held within the second table?

if so, you can set the query column to a dlookup to display the data within the desired column

Cheers

Leon

[djdaveg]

not that you can accurately match record by record, for example there is a column of postcode prefixes i.e. BB and town e.g. Blackburn

[Echidna]

Hi,

Only thing i can think of is adding a column to the primary table which would reference the ID of the secondary table, then populate the primary table's value from a function call like :

http://mvps.org/access/strings/str0003.htm

Hope this helps.

Cheers

Leon

[djdaveg]

Hi Leon,
Thanks for your help, I will give this a go

[Echidna]

Glad I could help

Cheers

Leon