Joining existing records in two tables

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hello all,
I have three tables with 1 to many relationships.

TableA 1 to many TableB
TableB 1 to many TableC

The PK of A is in B, and B's PK is in C.

My problem is that table C already existed with data in it.
Tables A and B are imported data, so none of the related Key fields have
their corresponding ID number in them.

I want to make a form that will allow the user (just one) to connect all the
records together. I've tried making some forms with drop downs, but even
though it shows the corresponding records and lets you choose it, it makes
another record in the table your trying to use (as oppossed to actually
connecting two already existing records).

Thanks beforehand,


.

Relevant Pages

  • Re: 3 tables join
    ... from TableB and TableC depending on the key in TableA. ... TableB - columns{id, column1} ... the query should match the related key to the id of TableA or table B ...
    (comp.databases.oracle.server)
  • Re: select Statement w/i inner joins
    ... In my below example number 1 does not have any data in TableA or ... TableB therefor I do not want it in my results ... Number TableB Amount TableC Amount ... Please reply to the newsgroup. ...
    (microsoft.public.access.queries)
  • Re: SQL server DB design question
    ... > TableA. ... DB2 has TableB and TableC. ... > IDB ...
    (microsoft.public.sqlserver.server)
  • RE: Relational dependency checker for deleting a row
    ... create table tableBunique, colA int not ... create trigger trTableA_IO_Delete on tableA ... create trigger trTableB_IO_Delete on tableB ... insert into tableC values ...
    (microsoft.public.sqlserver.programming)
  • Re: 3 tables join
    ... from TableB and TableC depending on the key in TableA. ... TableB - columns{id, column1} ... the query should match the related key to the id of TableA or table B ...
    (comp.databases.oracle.server)