Link to home
Start Free TrialLog in
Avatar of Czher
Czher

asked on

Filtering of information of database using other database

hello experts,

I have 2 database (Maindb and weldersdb), and a form (MAINFRM), eventually mainfrm is linked to maindb, now some information i need to show from weldersdb in mainfrm based on the data i typed
example
Weldersdb information

Welders     Process
ERS-001         S
ERS-002         F
ERS-003         S

now, if i type 'S' in the fileds 'process' in mainfrm the welders will show only 'ERS-001' and 'ERS-003', and if i type 'F', 'ERS-002' is the only welders that will show.

Can anybody help me with this.

Thank you

CZHER  
 
Avatar of Jerry Miller
Jerry Miller
Flag of United States of America image

If you have linked tables, then you can create parameter queries on any field in the table and filter it as you please.

http://www.ehow.com/how_2020612_create-parameter-access.html
Avatar of Rey Obrero (Capricorn1)
you create a link from Maindb to the table in weldersdb

file > external data > linked tables


once you have created the link, you can then use the linked  table like a local table
* as a record source of a form
* as row source of a combo/list  box

i don't exactly understand what you meant by this

<now, if i type 'S' in the fileds 'process' in mainfrm the welders will show only 'ERS-001' and 'ERS-003', and if i type 'F', 'ERS-002' is the only welders that will show.>
Avatar of Czher
Czher

ASKER

capricorn1,

in mainfrm there is a fields (welders, date, process),

This is the informaiton you're gonna see in weldersdb

Welders     Process
ERS-001         S
ERS-002         F
ERS-003         S

This is the information you're gonna see on MAINFRM

Welders       Date       Process
ERS-001   01/01/11        S


as ive mentioned above

if i type in mainfrm 'process' = 'S' the welders in combo box that will show is 'ERS-001' and 'ERS-003', but if i typed in mainfrm 'process' = 'F' the welders in combo box that will show is 'ERS-002'

in other words welders that will show only in combo box in mainfrm is depending on the process i will typed.

I hope this is clear

Can you upload you DB with sample of data?
Avatar of Czher

ASKER

I uploaded the DB, if you check the Welderdb each welder has a corresponding process, what i want to do in mainfrm is when i type or select in process field 'S' or 'F' or anything, not all welders will show but only those welders with the same process  that i type will only appears.

I hope this file will help you understand what i need.

Thanks
WeldSys.mdb
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
See my Fancy Filters database for an example of filtering a subform by a number of different values (different data types).  Here is a link for downloading it:

http://www.helenfeddema.com/Files/accarch129.zip

and here is a screen shot of the main form:
Fancy-Filters-Form.jpg
Avatar of Czher

ASKER

Capricorn1,

Thank you verymuch for the help, but why everytime i add a line and select a process, those previous line i already  selected, the welder is disappearing?