iopwinner.blogg.se

UNIQUE KEY IDX_Assignment_PK ( Assignment_Number, Cust_ID), PRIMARY KEY ( Assignment_Number, Cust_ID),

My table schema for assignment and assignment_detailsĪssignment_Number int(10) unsigned NOT NULL AUTO_INCREMENT,Ĭust_contact_id int(11) unsigned NOT NULL, The detail table is : assignment_details table. My solution right now is not too good, because i have to select the vendor_id in both of them. Master-detail table, linked by "ordernumber" (integer). In master table, i have a field called "vendor_id" (integer), and based on that id, i want to select products only from that vendor in my details table. I'm using master-table feature to make order form, but i need your help to give me direction on how to get the master table field value as filter on my detail tables.