I am trying to create a software to manage a second-hand shop. In this shop a client can be both a buyer (CLIE1) and a supplier (CLIE2), as seen in the relational model bellow:
I want to have in the form for the clients (area CLIENT1) the information of all the pieces that they have purchased and the pieces that they have supplied in two different table lists, but so far I can only manage to put one list in the form, as so:
How can I have this two information in the form of one client?
In order to accomplish that you must create an unfiltered table list, where genio does not make mandatory the tables to be related, and you can put the columns that you intend to use.
After you need to create a manual control (manwin) to filtre the table list, because if you publish you'll see as the name hints all the records on the database table.
The manwin is quite simple. As you can see in my example. The type is OVERRQ and parameter is the name of your Form followed by "_" and the name of the Unfiltered table list itself.
As for the code, is just a line similar to the one I show below, where you indicate the conditions to limit the table by the key of the form's table.
Seeing it by parts:
1 . "autob___pseudautautod"
- Identification of the unfiltered table list again but attention that now following the forms name there must be underscores to make 8 characters, followed by the table list name
- comand to compare and show the equal ones
- table related field of the area present on the table, attention the A is for Area is always needed and in caps (in your case must be CSGenioApeca1.FldCodclien2)
- here you say where the application gets the key, in this case the form in use through the navigation (in your case Clien1)
About This Community
|Asked: 12/19/19, 3:51 PM|
|Seen: 245 times|
|Last updated: 12/19/19, 6:06 PM|