Would this be possible with bBrowser
in [Visual Objects]
|
Prev: bBrowser and combobox
Next: CTYPE_8SPACE_GIF
From: Geoff Chambers on 9 Jun 2008 15:24 I have a SQL database that contains 2 tables The master table consists mainly of Code | Description 033500 Concrete the child table consists of Code | Submitted | From Sub | To Arch | From Arch | To Sub 033500 1 05/01/08 05/08/08 05/15/08 05/22/08 033500 2 05/22/08 05/25/08 033500 3 This file is currently an Excel file and they have all 3 submitted (the 12 dates) as one line. they claim there will never be submitted more than 3 times. Since I'm creating new tables I figured I would seperate out the dates, this way they wouldn't be restricted to 3 and most of them are only submitted once. I would like the Browser to display Code | Description | Submitted | From Sub | To Arch | From Arch | To Sub 033500 Concrete 2 05/22/08 05/25/08 But I would like the Column Submitted to be a combo box that would contain the number for each time submitted and by selecting 1,2,3.... the corresponding dates associated with that record would be displayed in the browse. Is this possible? TIA Geoff
From: Stephen Quinn on 9 Jun 2008 16:46 Geoff > Is this possible? Yes - your date columns would have to be #EXPRESSION type to get the data based on the result of the combo selection. CYA Steve
From: richard.townsendrose on 10 Jun 2008 05:51 Steve did you have a look at www.tdoc.net ? having a look at what you're doing, i can see much trouble ahead for you. what happens if the architect submits a 4th time .... and also what happens if he returns something approved, and then changes his mind and returns it with comments. contractually you need to record BOTH events (for the same rev) or as the yanks say "submittal" it is a LOT more complicated than you think.... i have been at this for 20 years and we really have only had it 100% right in the last 7. DONT convert from spreadsheets - think transactions like you would accounts invoice, credit note, payment over payment, under payment ad nauseam. or better still stock with fifo marking richard
From: Stephen Quinn on 10 Jun 2008 06:07 Richard > Steve > > did you have a look at www.tdoc.net ? It wasn't my question/post - I only supplied an answer which you replied to<g> > what happens if the architect submits a 4th time .... and also what From the child database it wouldn't matter how many times it was submitted - it's just another record CYA Steve
From: richard.townsendrose on 10 Jun 2008 06:14
Steve aplologies - my comment was meant for geoff ... doc control for construction is just a "little bit different" to what one expects. richard |