General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Larry,
Thank's for your reply, what you tell me was my first aproach to the problem, and that was the way that i have almost of my view's (no many at the moment..:) ), but for what i need i think don't work.
1. I need to create the grid in form in design time, not in the fly, because i need their columns methods avaiable, the grid have 4 columns but only 2 are editable.
2. i create the view with the fields that i need to build the grid, updatable, with ?CodCli, etc.
Then in the form init i requery the view with codcli='00000'(client) and i get the grid empty, until here ok. Then i select the client and build the select like you see, this select is not the same that i build the view, i can't do the same in the view designer, so i need to create the cursor and then append it to the view, is there another way to do that?
What i want to do is that, i have master table 'familias' that have all my group of produts like, NIKE, ADIDAS, ETC... and have another table 'clifamilias' that have the discounts for every client for this group of products, Ex: client 1 ADIDAS 3%, but client 2 ADIDAS 5%, and so on.
The select is important because if there are new groups it join them to the table clifamilias with no effort to the user, so it show the records that i have in table clifamilias more the new's one's that can be open in table familias.
Thank's in Advance
João Batista
Previous
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