I need help!

[mnl]

I don't know how to do it. I have
Contract table (Main Form)
Contract_Name
Contract_Address

Line table(Subform)
Line_No.
Contract_Name

Invoice table(Subform)
Invoice_No.


Invoice_Line_No.(Combo box with select L_No. from Lines
Contract_Name

I want to add data validation combo box?( that will call). I want my combo box list filter by Contract_Name. This is what I try to do; when I click on search button and find the Contract_Name, and then the data list from Invoice_Line_No. combo box change depends on the search data that I chose.
I've tried few days already. And I have no success.

Any help will be appreciated.

Thanks.

[orange]

Can you describe WHAT you are trying to do in plain English to give us some context for your problem/opportunity?
Could you show us your table and relationships as a jpg?

Once people have some knowledge of your environment and what you want to accomplish, they may have soome options and questions for you.

[mnl]

Thxs. Orange
Let me think how to explain it. I'm thinking to post the db file.

[ssanfu]

I have questions/comments:

Shouldn't use the period in field names

Linking using a text field??? Can be done but not the best - autonumber or unique long type field best

Invoice_Line_No.(Combo box with select L_No. from Lines ................ Lookup TABLES

FWIW, My 2 pennies......