View Full Version : Using data from one table in another?


tigercomaus
04-02-2007, 11:58 PM
I am very new to Access, so ecuse my ignorance.

I am trying to make a Database of incomming stock which can retrieve a stock description from another table(which I have imported from Excel) just by the part number. The excel table has part number, description etc, and I want to be able to get the appropriate desc. from the part number.

Any help will be appreciated.:)
I know little but can absorb alot( I am a sponge)
Bernard

ezfriend
04-03-2007, 09:37 AM
Can this be done by a simple select statement?

SELECT Description
FROM TheOtherTable
WHERE TheOtherTable.PartNumber = 'ThisPartNumber'