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
