D
Developer Dude
Guest
Hi:
I have two tables. One with customers (SE) and one with customer types (ST). Instead of placing the customer type in each customer record, I want to place a key value for the customer type instead. In this way, the Customer Type is only found once in the Customer Type table. I want to avoid data redundancy. Also, if I set up a new customer type and I mispelled it but didn't find out right away, I would only have to correct the error once and it would then appear correctly in each customer record.
Getting the combobox to enter the key value is no problem. What I can't figure out is how to set up a datarelation that will display the customer type in a label based on the key value. I am not using a datagridview but labels and textboxes.
There are multiple customers and multiple customer types so I guess that would be a many-to-many deal.
I would really appreciate some help.
Thanks
Continue reading...
I have two tables. One with customers (SE) and one with customer types (ST). Instead of placing the customer type in each customer record, I want to place a key value for the customer type instead. In this way, the Customer Type is only found once in the Customer Type table. I want to avoid data redundancy. Also, if I set up a new customer type and I mispelled it but didn't find out right away, I would only have to correct the error once and it would then appear correctly in each customer record.
Getting the combobox to enter the key value is no problem. What I can't figure out is how to set up a datarelation that will display the customer type in a label based on the key value. I am not using a datagridview but labels and textboxes.
There are multiple customers and multiple customer types so I guess that would be a many-to-many deal.
I would really appreciate some help.
Thanks
Continue reading...