PDA

Click to See Complete Forum and Search --> : 2nd time: implementing a many-to-many r'ship


Sep 20th, 2000, 06:35 AM
have a many-to-many r'ship, applicant & income_source. I have joined this many-to-many r'ship via an intermediary table (applicant_income_source). Please note that the income_source is a lookup table. The applicant_income_source table contains Applicant_ID, income_source_ID and income_amount. The income_source table contains Income_source_ID and income_source_type.
Is it possible to generate a data grid containing something like a combo box to enable users to select multiple income_source_types, enter amounts for each selected row and then store applicant_ID and income_source_ID and income_amount into the intermediary table.

Application used: VB6.0 / Access 2000 running on Windows 98

Your help is appreciated!

Cheers, Aussie

Sep 21st, 2000, 04:44 PM
i dunno if i'm wrong, but i don't think vb has that kind of a component yet, where the grid has other components embedded in it.

what you can do, though, is to add a combo box to your app and bind it to your datasource, and add a textbox for the amount of income.