Search results

  1. M

    SQL: 2 references from one table

    Oh ok thanks very much I was hoping there's a simpler answer :(
  2. M

    SQL: 2 references from one table

    Hi Just a little help on a seemingly easy question. Say I have 2 tables. 1. Transactions 2. Clients Each transaction has two clients. So transaction has client1ID, and client2ID With one client, I can just make an SQL query to do this: select t.*, c.name from transactions t, clients c...
  3. M

    Relational dropdown list issue

    Thanks a lot, that's exactly what i needed
  4. M

    Relational dropdown list issue

    Wow that was really quick Thanks :) I am not sure but looking into it now
  5. M

    Relational dropdown list issue

    Hi there, I have a simple 3 table relation, as listed: 1. Company 2. Company Contacts 3. Company Enquiries Here's a graphical representation of the tables: They are related as follows: 1. A company can have as many different company contacts as it needs. 2. A company can make an enquiry...
  6. M

    How to save "Attachment" objects automatically

    Admittingly I've cross-posted (http://www.dbforums.com/microsoft-access/1659135-how-do-i-save-attachment-objects-automatically.html#post6472194) Thank you very much for the answer
  7. M

    How to save "Attachment" objects automatically

    Hi, I have a need to output a list of about 22000 entries, each one with a JPG attachment, into a directory (i.e. save every attachment of every entry back into a file) However, there doesn't seem to be any immediate ways to do this other than clicking on each entry, then clicking on its...
Top Bottom