jswalker4
Posts: 8
|
| Posted: 09/22/2005, 11:47 AM |
|
Hi,
New to CCS. I have created a couple neat projects already but they have only involved one table. I need to have someone choose a list of addresses (and also show in the list box the city and state as well and haven't been able to get that to work)
Once they select an address I am trying to get a detail grid to link with it that will allow them to enter multiple detail records that pertain to that master record. It's an inventory program. I have tried to get the tutorial 'Simple' Master Detail to work to know avail. Is there anything else out there to view to help me?
Thanks
Jeff Walker
|
 |
 |
kevind
Posts: 251
|
| Posted: 09/22/2005, 5:25 PM |
|
what I like to do for the text value in a list box that contains the text contents from a number of columns is create a view of the underlying table that joins the text from a view columns
so in Access (for example) I create an expression like:
FullAddress: trim(street)+" "+trim(city)+" "+trim(any other columns)
I make sure the ID column of the table is in the view as column 1 - then in the form I make my bound column ID and text column FullAddress.
that's how I approach it - I find it easier than trying to get CCS to do it as a SQL statement.
Regards,
kd
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
jswalker4
Posts: 8
|
| Posted: 09/22/2005, 5:32 PM |
|
Kevin,
Thanks for the info. I am using SQL Server but I think I understand what you are saying and could do it in SQL Server I believe. I am still working out the second problem which is making this text box drive a detail section where inventory items can be entered against this address over and over again in a grid.
Jeff
|
|
|
|
|
