I am working on a Bid, Bid Details data entry screen and
have decisions to make on how to work with
Grids/Datasets/Lookups and Templates. My table layouts
are as follows:
Bid
Bid_ID, Company_ID, Bid_Date ...
Bid_Item
Bid_ID, Item_ID, Cost_Category_ID...
Item
Item_ID, Item_Name...
Item_Item_Category
Item_ID, Category_ID ...
Item_Category
Category_ID, Category_Name ...
When displaying the Bid Items, I wish to show the Name of
the item and category not the ids(Foreign Keys) and am not
sure if the grid should have a Select statement for it's
datasource, and if it does how does this affect changes
and updates, I know if the dataset is bound directly to a
table it isn't an issue.
My users are currently using a system where when they tab
I am working on the Bid, Bid Details data entry screen and
have decisions to make on how to work with
Grids/Datasets/Lookups and Templates. My table layouts
are as follows:
Bid
Bid_ID, Company_ID, Bid_Date ...
Bid_Item
Bid_ID, Item_ID, Cost_Category_ID...
Item
Item_ID, Item_Name...
Item_Item_Category
Item_ID, Category_ID ...
Item_Category
Category_ID, Category_Name ...
When displaying the Bid Items, I wish to show the Name of
the item, not the description and am not sure if the grid
should have a Select statement for it's datasource, and if
it does how does this affect changes and updates, I know
if the dataset is bound directly to a table it isn't an
issue.
I also have a couple quick questions on allowing users to
add records, should it be text fields on the form or a
second grid based on a select routine. My users are
currently using a system where when they tab off the last
fiend it auto adds a new record off the last field it auto
adds a new record.
Has anyone encountered examples which I could gain an
insight through
2  1226 
You can set up your grid to bind to a dataset and see that the tables have
the relations defined via a DataRelation object. This will allow you to
expand and collapse partent items and then edit/view the child records in
the same grid. I think this is what you are wanting to do right?
Also, if you want to do some fancy stuff with your gird, like adding
datetimeprickers and comboboxes, the Infragistics grid is a wonderful too.
"is**************@hotmail.com" <an*******@discussions.microsoft.com> wrote
in message news:05****************************@phx.gbl... I am working on a Bid, Bid Details data entry screen and
have decisions to make on how to work with
Grids/Datasets/Lookups and Templates. My table layouts
are as follows:
Bid
Bid_ID, Company_ID, Bid_Date ...
Bid_Item
Bid_ID, Item_ID, Cost_Category_ID...
Item
Item_ID, Item_Name...
Item_Item_Category
Item_ID, Category_ID ...
Item_Category
Category_ID, Category_Name ...
When displaying the Bid Items, I wish to show the Name of
the item and category not the ids(Foreign Keys) and am not
sure if the grid should have a Select statement for it's
datasource, and if it does how does this affect changes
and updates, I know if the dataset is bound directly to a
table it isn't an issue.
My users are currently using a system where when they tab
I am working on the Bid, Bid Details data entry screen and
have decisions to make on how to work with
Grids/Datasets/Lookups and Templates. My table layouts
are as follows:
Bid
Bid_ID, Company_ID, Bid_Date ...
Bid_Item
Bid_ID, Item_ID, Cost_Category_ID...
Item
Item_ID, Item_Name...
Item_Item_Category
Item_ID, Category_ID ...
Item_Category
Category_ID, Category_Name ...
When displaying the Bid Items, I wish to show the Name of
the item, not the description and am not sure if the grid
should have a Select statement for it's datasource, and if
it does how does this affect changes and updates, I know
if the dataset is bound directly to a table it isn't an
issue.
I also have a couple quick questions on allowing users to
add records, should it be text fields on the form or a
second grid based on a select routine. My users are
currently using a system where when they tab off the last
fiend it auto adds a new record off the last field it auto
adds a new record.
Has anyone encountered examples which I could gain an
insight through
You can set up your grid to bind to a dataset and see that the tables have
the relations defined via a DataRelation object. This will allow you to
expand and collapse partent items and then edit/view the child records in
the same grid. I think this is what you are wanting to do right?
Also, if you want to do some fancy stuff with your gird, like adding
datetimeprickers and comboboxes, the Infragistics grid is a wonderful too.
"is**************@hotmail.com" <an*******@discussions.microsoft.com> wrote
in message news:05****************************@phx.gbl... I am working on a Bid, Bid Details data entry screen and
have decisions to make on how to work with
Grids/Datasets/Lookups and Templates. My table layouts
are as follows:
Bid
Bid_ID, Company_ID, Bid_Date ...
Bid_Item
Bid_ID, Item_ID, Cost_Category_ID...
Item
Item_ID, Item_Name...
Item_Item_Category
Item_ID, Category_ID ...
Item_Category
Category_ID, Category_Name ...
When displaying the Bid Items, I wish to show the Name of
the item and category not the ids(Foreign Keys) and am not
sure if the grid should have a Select statement for it's
datasource, and if it does how does this affect changes
and updates, I know if the dataset is bound directly to a
table it isn't an issue.
My users are currently using a system where when they tab
I am working on the Bid, Bid Details data entry screen and
have decisions to make on how to work with
Grids/Datasets/Lookups and Templates. My table layouts
are as follows:
Bid
Bid_ID, Company_ID, Bid_Date ...
Bid_Item
Bid_ID, Item_ID, Cost_Category_ID...
Item
Item_ID, Item_Name...
Item_Item_Category
Item_ID, Category_ID ...
Item_Category
Category_ID, Category_Name ...
When displaying the Bid Items, I wish to show the Name of
the item, not the description and am not sure if the grid
should have a Select statement for it's datasource, and if
it does how does this affect changes and updates, I know
if the dataset is bound directly to a table it isn't an
issue.
I also have a couple quick questions on allowing users to
add records, should it be text fields on the form or a
second grid based on a select routine. My users are
currently using a system where when they tab off the last
fiend it auto adds a new record off the last field it auto
adds a new record.
Has anyone encountered examples which I could gain an
insight through This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Olivier Crèvecoeur |
last post by:
Hello,
Excuse me for my poor english.
I would kike know if create index on the foreign key it's necessary or if
Oracle, are optimized for using foreign key whithout index.
Best regards
...
|
by: Bodza Bodza |
last post by:
I'm having an argument with an incumbent self-taught programmer that
it is OK to use null foreign keys in database design.
My take is the whole point of a foreign key is that it's not supposed...
|
by: Vinodh Kumar P |
last post by:
I understand the number of foreign keys allowed is restricted by the DBMS I
use.
In a general relational schema design perspective how many foreign keys a
table shall have?
If I have large number...
|
by: is_grizzly_adams |
last post by:
I am working on a Bid, Bid Details data entry screen and
have decisions to make on how to work with
Grids/Datasets/Lookups and Templates. My table layouts
are as follows:
Bid
Bid_ID,...
|
by: Scott Ribe |
last post by:
I've got a problem which I think may be a bug in Postgres, but I wonder if
I'm missing something. Two tables, A & B have foreign key relations to each
other. A 3rd table C, inherits from A. A...
|
by: Stewart Allen |
last post by:
I have a form with 2 subforms; 1 displaying the modules a trainee is
currently doing and the second subform displaying the units that are
associated with the selected module while the main form is...
|
by: Ian Davies |
last post by:
I have created a database with about 17 tables. I have been creating foreign
keys some of which have worked but when creating others I get the message
below
*************************
1005...
|
by: sonal |
last post by:
Hi all,
I hv started with python just recently... and have been assigned to
make an utility which would be used for data validations...
In short we take up various comma separated data files
for...
|
by: rbarber |
last post by:
I have to synchronize 2 databases hourly but am having difficulty maintaining foreign key relations. These tables use auto-increment columns as primary keys, with child records in other tables...
|
by: apax999 |
last post by:
Kinda new to SQL, using SQL Server 2005.
I have some foreign keys in a couple of tables. I need to drop these
tables, but can't since I'll get the error:
Msg 3726,
Level 16, State 1, Line...
|
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,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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...
|
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...
|
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
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
| |
