Drag fieldnames into query

[john]

In the query builder I made an edit-query in which I have linked table A to
table B on IDnr. For every record that matches I want 5 fields of table A to
get the values of corresponding fields in table B. I'm able to make this
query but only by typing the table B fieldnames in the 'change to'-row. Is
there some easy way to drag those fieldnames to that row or another way to
make this easier?
Thanks,
john

[Kc-Mass]

You can drag the tablB fields into their own space in the grid. You would
then be able to copy and past, first the tblB tablename and then the tblB
fieldName and the put a dot between them.
Only worth doing if the table and field names are complex and typing error
prone.

Kevin C

"john" <jo**@test.comwrote in message
news:Mv********************@casema.nl...

In the query builder I made an edit-query in which I have linked table A
to table B on IDnr. For every record that matches I want 5 fields of table
A to get the values of corresponding fields in table B. I'm able to make
this query but only by typing the table B fieldnames in the 'change
to'-row. Is there some easy way to drag those fieldnames to that row or
another way to make this easier?
Thanks,
john

[john]

OK, thanks.
john

"Kc-Mass" <co********@comcast.netschreef in bericht
news:P8******************************@comcast.com. ..

You can drag the tablB fields into their own space in the grid. You would
then be able to copy and past, first the tblB tablename and then the tblB
fieldName and the put a dot between them.
Only worth doing if the table and field names are complex and typing error
prone.

Kevin C

"john" <jo**@test.comwrote in message
news:Mv********************@casema.nl...

>In the query builder I made an edit-query in which I have linked table A
to table B on IDnr. For every record that matches I want 5 fields of
table A to get the values of corresponding fields in table B. I'm able to
make this query but only by typing the table B fieldnames in the 'change
to'-row. Is there some easy way to drag those fieldnames to that row or
another way to make this easier?
Thanks,
john