Search results

  1. R

    innjer join issue

    My understanding of inner joins and what i've read is that it displays a subset of records only present on both sides of the table according to the fields they are joining on. So in my experiment, I have table A which has some duplicate records. I select disticnt on field1 and make a new table...
  2. R

    import or update into a combo box field from a non combo field

    Hi, I have 2 tables A and B. A table has a field that is a combo box obtained from a query from another table say C. Table B is an import from excell and so I intend to populate table A with it. Im able to update other fields on table A but not this particular field that is a combo box...
  3. R

    Question how to delete rows that match other rows in different table

    Searched but to no avail to what appears should be a simple delete thing. I have 2 tables which I can easily create a select query, relate 3 columns together and view their records. Nice. Now change that to a delete query and run, I get the message "Specify the table containing the records...
  4. R

    Question Howto import data in related tables with existing records

    I had followed the post http://www.access-programmers.co.uk/forums/showthread.php?p=849961 but im quiete concerned with the pk. I have a few related tables which they all branch off from a main table. Lets call it the top level table. Also the top level table already has records and it's pk...
Back
Top Bottom