Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Kash
Lv 4
Kash asked in Computers & InternetSoftware · 1 decade ago

Foreign Keys and Reports in Microsoft Access?

So here is the deal. I have 2 tables. One is Product, the other is ProClass. The Product table holds the numerical primary key of the ProClass table as a foreign key. The ProClass table has 2 fields. The primary key and a text field.

Now, I want to make a report that shows all the fields of the Product table, but when it gets to the ProClass foreign key, I want it to show the value of the text field that foreign key relates to in the ProClass table. Is there a way to do this in the expression builder? I know how to do this with a query, and I could just make a report out of the query, but I would like to do it the way I mentioned above.

Thanks in advance

1 Answer

Relevance
  • Anonymous
    1 decade ago
    Favorite Answer

    Do it the way others do it.

Still have questions? Get your answers by asking now.