Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Populating a grid and a combo box with a foreign key
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
The Mere Mortals Framework
Divers
Thread ID:
00659857
Message ID:
00660026
Vues:
23
Hi Kevin,

I'm sorry for the confusion. I really think now that this is an unusual scenario. I'm really wondering if this is possible or I should think of other way of doing it. But anyway, I will give you the details of my 2 views.

I am using two business objects for my 2 views.

View 1 contains product category which is an integer. The second field is a character product description. This is loaded in a combobox in page 2 of my page frame. I put my business object for this view on this page.

View 2 contains iID (uniquefield), integer product category (foreign key from view 1), char product name and a char supplier name field. This is loaded in a grid in page 1 of my page frame. I put my second business object here and it is the primary.

View 1 has a one-to-many-relationship with my view 2.

After my form loads, in page 1, my records (view 2) are displayed on the grid starting from products with a category of 1 and so on. I click page 2 and see the first record (view 1) in my combobox. I click the combobox and choose the second category or category 2. If I click back to page 1 to see my grid, I am expecting to see only the records belonging to category 2.

I hope that my explanation is clear now.

Thanks a lot Kevin.

Nerissa Dela Rosa
McFadden's
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform