Najm; Try this:
1. In the Invoice table, make the Project Number AND the Customer Number a two-part key field. You can do this in the design view of the Invoice table by selecting both fields and then clicking the key button on the toolbar. 2. Make sure the Customer Number is a key field in the Customer table. Also, make sure the data types for the Customer Number are the same in both the Invoice and Customer tables. 3. Create a query and join the Customer Number fields for both tables. Make it a one to many join with the "many" side on the Customer table. 4. Drag the table fields you want to see in the query to the table lines below the image of the two tables (still in the query design view). 5. Open the form in design view and set the form's source to the query you just designed. If I understood you properly, I think this will take care of your problem. Sincerely, John A. Carter --- In [email protected], "NET NEWS" <najb...@...> wrote: > > I need a small help from any one. > I have a table named Invoice with feilds Project# and customer #.Both of this > feilds are selected as combo box with source from two diff tables. Cusotmer & > Project. > In Invoice table, in feild of cusotmer, I make the colum count to 2 to see > cusotmer code and customer name when clicking combo box, inorder to > understand the cusotmer.But I need onky the customer code to be stored in > Invoice table (customer feild). Its working. > > But when I am making relationships between cusotmer and invoices table, no > relationship is creating becuase of two feilds. > > Clould you please help. > > Najm >
