Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Populating a grid and a combo box with a foreign key
Message
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00659857
Message ID:
00660026
Views:
21
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform