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
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
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.>
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.>
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
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?
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
I hope this file will help you understand what i need.
Thanks
WeldSys.mdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
http://www.helenfeddema.com/Files/accarch129.zip
and here is a screen shot of the main form:
Fancy-Filters-Form.jpg
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?
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?
http://www.ehow.com/how_2020612_create-parameter-access.html