Results 1 to 2 of 2

Thread: 2nd time: implementing a many-to-many r'ship

  1. #1
    Guest

    Question

    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

  2. #2
    Guest
    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
  •  



Click Here to Expand Forum to Full Width