Sep 17th, 2000, 01:52 AM
I 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
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