473,387 Members | 3,033 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Simulation of Access DB Lookup Table Type

I have several comboboxes on a form that are bound to the same dataset. I
want to simulate the Access Lookup Table in these comboboxes. That is, I can
select a value loaded in the combobox without changing the selected value in
another combobox that is bound to the same data. I have been reading about
CurrencyManagers but how could I use this to help? If it is possible at all.
--
L. A. Jones
Oct 24 '06 #1
1 1384
It's certainly possible, but probably less likely with off-the-shelf
built-in automatic data binding. Usually, if you want to do something
like this, you need to do one or both of the following:

1. Uncouple from data binding and populate things manually. It's less
clean and pretty, involves more code, but can always get your job done.
List<and Dictionary<objects (ArrayList and Hashtable if you're in
1.1) provide rich data handling. You may also be able to create a typed
custom DataSet that contains some extra columns to drive your extra UI
elements.

2. Extend a data provider or provide your own. Your custom data
provider will contain all the methods and bindings you need to display
the data as you want it.

Either way, this looks like the perfect application to create your own
custom control. You may also be able to find a source repository that
has an existing control similar to this that you can use or extend.
Stephan


Dave wrote:
I have several comboboxes on a form that are bound to the same dataset. I
want to simulate the Access Lookup Table in these comboboxes. That is, I can
select a value loaded in the combobox without changing the selected value in
another combobox that is bound to the same data. I have been reading about
CurrencyManagers but how could I use this to help? If it is possible at all.
--
L. A. Jones
Oct 24 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Vladimir | last post by:
Hello, I have a table in MS Access database. It has one field (with BYTE datatype) that has several properties set in Lookup tab of table Design View. Display Control = Combo Box. Row Source...
30
by: Andante.in.Blue | last post by:
I just browsed through some of my Access links when I came across the Ten Commandments of Access (http://www.mvps.org/access/tencommandments.htm). Some of the points I heartily agree with (and...
22
by: script-learner | last post by:
I currently own a fruit and veg business and wish to compuiterise my manual methods in order to reduce labour costs. I spoke to my son who is a whiz on computers and he had a good chat with me and...
0
by: TheCoder | last post by:
I am making a D-base with web conectivity for my class project. I have everything working but the subit button sends the data to the correct fields but afterwards it wants to reproduce new blank...
9
by: Mike McGee | last post by:
I am new to database apps, but I am making a db with access 2002. Here is what I have and what I would like for it to do. tblCustomers = holds customer info (Name, Address, City, State, Zip,...
2
by: Acephalus | last post by:
I am currently using this to get data from an .xls file:string conn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + file + ";" + "Extended Properties=Excel 8.0;";...
8
by: Darryl Kerkeslager | last post by:
Currently I am using the RegExp object to parse a large dataset in an Access table - but this table was exported from SQL Server, and the very correct question was asked - why not just do it in SQL...
6
by: Adam Donahue | last post by:
As an exercise I'm attempting to write a metaclass that causes an exception to be thrown whenever a user tries to access 'attributes' (in the traditional sense) via a direct reference. Consider:...
4
by: netnewbie78 | last post by:
Hello All, I don't have a problem (but maybe I will after I explain). I have a question with regards to something I saw in Access 2007. But first, a little backstory: I'm writing a very small...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.