Hente felt fra anden tabel

If you have a relationship between the two table then make a query including fields from BOTH tables. Then us eth equery in the form instead of the table.

You can also use the dlookup funtion to get a value from another table


Me.somefield = Dlookup("FieldName","TableName","SomeField = " & somevalue)

Med en udvælgsesforespørgsel får jeg flg sql:

SELECT Tabel1.ID, Tabel1.farve
FROM Tabel1 INNER JOIN Tabel2 ON Tabel1.ID = Tabel2.ID;

men det giver INGEN farve i tabel2.farve ved valg af id i table2.
Dlookup kan jeg ikke rigtig se hvordan jeg kan bruge?
Er sql herover rigtigt?

SELECT Tabel1.ID, Tabel1.farve, Tabel2.farve
FROM Tabel1 INNER JOIN Tabel2 ON Tabel1.ID = Tabel2.ID;

If you use the query builder in Access you can select all of the fields you want to see visually!

Jeg får nu "valgmuligheden" mellem farverne fra tabel1.farve,
men det er ikke hvad der ønskes.
Farven skal stå i farve i tabel2 "automatisk" på baggrund af
indsat id i tabel2.
Jeg indrømmer jeg har ikke styr på de forsk. valgmuligheder i
OPSLAG: der findes i
Viskontrolelement: tekstboks,liste,kombi i  -
rækkekildetype:tabel/forespørgsel, værdiliste, feltliste og i
rækkekilde vælger jeg queryen jeg lavede med ovennævnte sql.
Dette gælder for feltet tabel2.farve.
Hvor går det galt?

The problem is that we do not know 100% what it is you are trying to do!

Try giving an example of your data and what EXACTLY you want?

Very simple:
I want to be able to select the right "farve" from
table1, when I make a choose in table2´s ID.
Eg. I have table1:
id:1 -farve:hvid
id:2 -farve:sort
I now go to table2 and choose id:2 and then I want
to be able to see "sort" in table2.farve.

I have this in Table2.id´s rækkekilde:
select distinctrow table1.id from table1

and in Table2.farve´s rækkekilde:
SELECT Tabel1.ID, Tabel1.farve, Tabel2.farve
FROM Tabel1 INNER JOIN Tabel2 ON Tabel1.ID = Tabel2.ID;

I have a feeling we are getting things mixed up!
When you say table dont you mean a combo (drop down)?

If you can send your dB to NOSPAMeksperten@santhell.dkNOSPAM then I maybe have a better chance of understanding what it is you are doing! I also have a bit more time as I am at work at them moment!


remove NOSPAM

I will look at it this evening after work!

Have you received the dB I sent?