Foreign key data binding (VB2010 & access2007)
Foreign key data binding (VB2010 & access2007)
Foreign key data binding (VB2010 & access2007)
Foreign key data binding (VB2010 & access2007)
Foreign key data binding (VB2010 & access2007)
Foreign key data binding (VB2010 & access2007) Foreign key data binding (VB2010 & access2007) Foreign key data binding (VB2010 & access2007) Foreign key data binding (VB2010 & access2007) Foreign key data binding (VB2010 & access2007) Foreign key data binding (VB2010 & access2007) Foreign key data binding (VB2010 & access2007) Foreign key data binding (VB2010 & access2007)
Foreign key data binding (VB2010 & access2007) Foreign key data binding (VB2010 & access2007)
Foreign key data binding (VB2010 & access2007)
Go Back  Xtreme Visual Basic Talk > > > Foreign key data binding (VB2010 & access2007)


Reply
 
Thread Tools Display Modes
  #1  
Old 03-09-2014, 03:05 AM
oliverfe oliverfe is offline
Newcomer
 
Join Date: Mar 2014
Posts: 1
Unhappy Foreign key data binding (VB2010 & access2007)


Hi Experts, i'm so glad able to join on this forum.
before i tell the problem firstly i'd like to show these 3 tables and their relationship created with access 2007.
COUNTRY
country_code | country_name
1 | USA
2 | SPA

PERSON
person_id | person_name
AA | Andy
BB | Oliver

COUNTRY-PERSON
Id | Person_id | Country_id
01 | AA | 1
02 | AA | 2
03 | BB | 1

in VB2010, i created 2 comboboxes :
1) cbx_country, country_name as the DISPLAY MEMBER
country_id as the VALUE MEMBER
2)cbx_person, id field of country-person table as the VALUE MEMBER
in this case, i want the person_name field of person
table as the DISPLAY MEMBER, How to set this ?

And Here is the scenario :
1) first, i choose the country by using the cbx_country, say : 1 (USA)
2) then, in the cbx_person, i want to set this combobox to display the person_name (not the person_id which is as foreign key in country-person table) where country_id = 1 (means that : it will display the name of the person who has house in USA, in this case those sould be : Andy | Oliver) and put the result of it into cbx_person as the DISPLAY MEMBER, and i want the DISPLAY VALUE is id field of country-person table.

if possible, is there any way to solve this without writting any code ?(i hope YES).
may be just use the combobox tasks tool ?

thanks in advance
Reply With Quote
Reply

Tags
access 2007, foreign key data binding, vb2010


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Foreign key data binding (VB2010 & access2007)
Foreign key data binding (VB2010 & access2007)
Foreign key data binding (VB2010 & access2007) Foreign key data binding (VB2010 & access2007)
Foreign key data binding (VB2010 & access2007)
Foreign key data binding (VB2010 & access2007)
Foreign key data binding (VB2010 & access2007) Foreign key data binding (VB2010 & access2007) Foreign key data binding (VB2010 & access2007) Foreign key data binding (VB2010 & access2007) Foreign key data binding (VB2010 & access2007) Foreign key data binding (VB2010 & access2007) Foreign key data binding (VB2010 & access2007)
Foreign key data binding (VB2010 & access2007)
Foreign key data binding (VB2010 & access2007)
 
Foreign key data binding (VB2010 & access2007)
Foreign key data binding (VB2010 & access2007)
 
-->