same value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a join with several tables. I want the resultant "records" all to have an identical value attached. I wrote
Select "Mark R" as Testname and of course every resultant record has "Mark R" attached. But what if I want the user to be able to change "Mark R" to "Sam K". I would want a table with a single record with a single field containing the name
But how do you do the join? All the other tables have Auto ID as a key and there are hundreds of records. This "name" table has a single record with no relevant key. Do I use Union? Do I do a Union after the multi-join? Is there a place on the web I can read about it and see examples.
 
Hi Mark,

One method would be to use DLookup
to provide your Testname in the query.

SELECT
DLookup("singlefield","singlerecordtable") AS TestName,
........
FROM
..........

replacing "singlefield" with actual name of field
and "singlerecordtable" with actual name of table.

Please respond back if I have misunderstood.

Good luck,

Gary Walter

mark R said:
I have a join with several tables. I want the resultant "records" all to have an
Click to expand...
identical value attached. I wrote
Select "Mark R" as Testname and of course every resultant record has "Mark R"
Click to expand...
attached. But what if I want the user to be able to change "Mark R" to "Sam K". I
would want a table with a single record with a single field containing the name.
But how do you do the join? All the other tables have Auto ID as a key and there
Click to expand...
are hundreds of records. This "name" table has a single record with no relevant key.
Do I use Union? Do I do a Union after the multi-join? Is there a place on the web I
can read about it and see examples.
 
AH, in this case you DON'T do the join to the one record table. You include it
and do not join it to any of the other tables.

SELECT OneRecordTable.FixedTable, OtherTable.*, OneMoreTable.*
FROM OneRecordTable,
OtherTable INNER JOIN OneMoreTable
 
Back
Top