General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Help for the following problem
A Customer table has customer information.
A Group table has a group information.
A group can have multiple customers.
A customer can have multiple groups.
So I created a table which links both of them.
In this table I am storing Customers and GroupCID and there is No Primary Key (PK is linkcustomerCID+linkGroupCID) because many records will be deleted and added and not updated.
On the customer form I have provided a Grid with GroupTextbox which shows all the groups and a checkbox where user can select/deselect group by clicking the checkbox. I can not change this interface because client wants this way.
Same logic is for Group Form.
(1) How do I refresh this grid so that correct values of checkboxes appear, I mean ticked where there is a groupCID in linkCustomerGroup Table or blank when there is no GroupCID of GroupTextBox (grouptextbox shows only groupname and not groupcid, this is also the problem.
(2) When User selects/deselects more than one group I will have to either add multiple records or delete multiple records
(3)Will it be possible to create a single view which will show all the groups and update the Linktable. I tried it with OUTERJOIN View (All records from GroupTable +records from linktable which has a matching CID) but whenever I replace .NULL. value with actual Valid Value VFP pops up error message UPDATE Conflict.
(4) what will be the coding part on the grid or save method.
Sanjay Chavda
sanjay@telebot.net
Any Help
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only