473,387 Members | 1,606 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.

Backfill cascacade Combo Boxs

1. I have Cascade Combo Box’s that will select a product:
MFG combo Box i.e. Aurora
Brand combo Box i.e. Aurora Natural
Product Group combo Box i.e. Trail Mix
Product Selection combo Box i.e. 5K Omega Trail Mix
-----------------------------------------------------------------------
2. Need backfill combo Box’s when I go straight down to Product Selection:
MFG combo Box i.e. ????????? (Aurora)
Brand combo Box i.e. ????????? (Aurora Natural)
Product Group combo Box i.e. ????????? (Trail Mix)
Product Selection combo Box i.e. 5K Omega Trail Mix

===============================
Thank you greatly appreciate your help!!
Dec 31 '15 #1
1 954
zmbd
5,501 Expert Mod 4TB
Before we start on this odyssey - You shouldn't be doing that in a properly designed cascade.
home > topics > microsoft access / vba > insights > cascading combo/list boxes

You provide no insight in to the design of your database nor to how these cboxs supposedly relate to each other in a "cascade"

Think about it for a moment.....

take for example:
table1 is 1:M with table2 which is 1:m with table3 which might be M:M with table4 which is m:1 with table5 in each of these say there are dozens or hundreds of relationships.....

what you are asking is to tell you which specific records in table1, table2, table3, and table4 would have been selected to get to the record of interest in table5... we might be able to go from table5 thru table4 to table three if you setup table4 to prevent duplicate pairings between table3 and table5's keys; however, the likelihood for going back from table3 back to table2 to table1 decreases each time and exponentially so as the number of records increase!
Dec 31 '15 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Heather | last post by:
Hi I am desparately looking for advice in relation to storing the results after selecting items from two combo boxes on a Referral form. The first combo box 'ctl Type' displays a full list of...
2
by: Jeff Mason | last post by:
I'm observing some strange behavior when I use a bound combo box in conjunction with the combo's anchor property. I define a form which contains just a textbox and a combo box. The text box is...
3
by: sbetancourt | last post by:
Hi, I am making a database that will look up an employee in the main form and in the subform I can see their tasks. The subform is in a datasheet view and it has a combo box that allows you to...
17
by: shivasusan | last post by:
Hi! In my program, I have multiple check boxs.(more the 10) But i give rights to select 2 check boxs, If i select more then 2 check boxs, I want to display alert message. Please any one post...
9
by: bdominiq | last post by:
I have three diferent combo boxs I want to sum the second column of each combo box after update. I tried to sum the selection on a different text box, but it row them up on the text box. How can you...
1
by: Gordon Padwick | last post by:
I have a combo box in Access 2003 that contains three columns from a table. The combo box correctly lists the contents of those three columns. I have one column specified as the bound column, so when...
4
by: Wornout | last post by:
My form Recipes has 3 sub forms each has a Master/Child to a combo box. each combo box is bound to a field on the form/recipes table but instead of saving all what picked in the combo boxs to one...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
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: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
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,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.