I have a database where I enter part number description, and cost. I also have another database that is updated all the time with this information in it. I would like to be able to link or however you do it. I would like to lets say put in the part number and then when I push enter or tab the description and cost field populates.
you can link by selecting the table tab in the DB window and then click NEW followed by selecting Link. Then search for your other database and select the table you want to link to.
You will now have access to all the fields, it is the same as a table now except you may have sharing issues if the table is opened on the source DB.
You can use this linked table just as a regular table to make reports forms, queries etc. so you may not need the table you created with the same information as it is redundant.
So you can make a form with your linked table with a combo to select the product.
=========================================================
I don't know to what degree of detail you want or how much you know so if you need more help just post back.
I have a database where I enter part number description, and cost. I also have another database that is updated all the time with this information in it. I would like to be able to link or however you do it. I would like to lets say put in the part number and then when I push enter or tab the description and cost field populates.
any help would be great.
----------------------------------------------------
Not sure how new you are to Access, however, linking tables requires that ONE field in the two tables MUST be identical for the linking to work properly. For instance PART NUMBER should be a Key Field in one table and included at least as a field in the second table, not as a Key Field.
JESSE
Status
Not open for further replies.
You have insufficient privileges to reply here.
Related Threads
?
?
?
?
?
Tech Support Guy
9.9M posts
859.7K members
Since 1998
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!