Hi,
i want to retrive data from a table which has a composite primary key. This is the query
im using;
"select price from Item_size where primarykey='"+pk+"'"

But it does not work. Im using MS Access. can anyone help me!

A composite key means the key consists of two or more fields.
"select price from item_size where field1 = "something" and field2 = "smethin else" and ..."

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.