Search results

i have a form based on a table which holds the info about software on a PC i want to add a text box to allow me to view the pc number of a pc when its selected on the form the pc number is in a different table and when i try to use the control source in properties and use the expression...

Can i create a query where each time i use the query i am asked to enter a number to search for. e.g. i have a pc data table with pc number as the primary key can i create a query where it will ask me to enter the pc number and then find the pc i am looking for in the table.

reply to searching for records No I have the two tables PC(all data about a pc) and pc software(software on all pc's) my for is based on pc and the pc number is primary key is it possible to search by pc number in the software table to find the pc and bring up the details about the software...

i have a form which hold the data about a pc i want to be able to bring up information about what software is on that pc the software of each pc in a seperate table. i was wondering is it possible for me to look through my pc's and click on a particular pc and be able to find the info about...

do you know how i would populate the table with a query??

Ive tried this and got to the stage where i have a table with the pc number and software id but their is no data in this table how do i populate this table with data.

I am looking to lonk tables in a database. I have one table a pc tables which has a list of pc's the other table is a pc software table which has a list of software i want to build a form to show the pc's and their software how do i do this