combo boxes followed by subform

[kimhoong79]

have a database containing tables as shown below:

System Function FuncFailMode
------ -------- ------------
SysID ---- SysID ---- SysID
SysName FuncID --- FuncID
FuncName FuncFailID
FuncFailName

I need to build a form for adding/updating data for the FuncFailMode table. I'm planning to build 2 combo boxes for the SysID and FuncID selections following with a subform containing FuncFailID and FuncFailName.

My problems are
1. The SysID combo box that I've created using the Function table contains duplicated data. Is there anyway to limit the duplicated data?

2. The second combo box won't synchronize or filtered itself according to the first one.

3. Even if I can solve these problems, it bring forward these 2 values to the subform.

4. If possible, tell me how to build similar database like this but with 3 combo boxes.

Please help!

ps: I don't have any knowledge on marcos, module and VB.

Thank you

 

[ToeShot]

Read this thread
thread700-144341 Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait

 

[kimhoong79]

thanx ToeShot, I followed the thread that you've showed me but I still have one problem, the second combo box doesn't "refresh" after the value of the first combo box is selected. FYI, I'm using Access97. Also, I just wanna make a remark that my database is base on something like what I've shown above, NOT like the one below

System Function FuncFailMode
------ -------- ------------
SysID ---- SysID SysID
SysName FuncID --- FuncID
FuncName FuncFailID
FuncFailName


I like to ask if there's anything different in implementing the combo box for these two database.

 

[kimhoong79]

ToeShot, can you let me have the exact database(sample) a look? I mean, can u email it to me or upload it somewhere for me to download? thank you

 

[ToeShot]

Give me your email address and I will zip it and send it to you. Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait