Search results

  1. M

    Creating 3rd table containing stuff from 2 other tables

    Yea, that's why I delayed with reply. I was making sure everything is clear for me, so in case it wasn't i i could just ask in reply. :D Wasn't it what I wrote? Well, at least it was what I meant :) Well, i guess my question was very basic though :cool: I don't mind!:p
  2. M

    Creating 3rd table containing stuff from 2 other tables

    I delayed with replay to check if I wont have any more problems/question, but it seems I don't and wont have (at least in this topic). I would like to thank you once again for your help and those demo databases. It helped me big time!:) Marry me. :D
  3. M

    Creating 3rd table containing stuff from 2 other tables

    Bah... i said it to early i guess... I mean, no, everything is working but as long as i have two tables only, and as topic says, there is this unlucky third table :( Besides tables Producers and Things, i do have a third table Sales. Sales contains Producer_ID, Thing_ID and Sold_Date. So i was...
  4. M

    Creating 3rd table containing stuff from 2 other tables

    I would like it to have a list of all my Things by specific Producer (after I choose producer in first combo box).
  5. M

    Creating 3rd table containing stuff from 2 other tables

    Rep points added, but I have just one more question. Is it possible to have 2 combo boxes instead of 1 combo and 1 text field (like in your demo database)? I've been trying to do that, but somehow it keeps listing me only first record of that specific producer...
  6. M

    Creating 3rd table containing stuff from 2 other tables

    Thanks alot Mr. B for your long reply, that was indeed what I wanted, i just couldn't see it. And thanks a lot for that database, it helped lot! :) I'm really grateful for that.
  7. M

    Creating 3rd table containing stuff from 2 other tables

    Thanks, but I think it's not what I'm trying to do. I have a form with both Producers and Things column, and what I'm trying to do is to make Things list display only Things wich were made by Producer set in first column. :confused:
  8. M

    Creating 3rd table containing stuff from 2 other tables

    Hello, First of all: Hello to all :) I have 2 tables: 1. Producers - contains 'Producer_ID' and 'Producer_name' 2. Things - contains 'Thing_ID' 'Producer_ID' from Producers and 'Thing_name' I want to create 3rd table where when I choose Producers_ID, i can only see 'Thing_name' made by this...
Back
Top Bottom