|
-
Sep 20th, 2000, 06:35 AM
#1
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
#2
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|