same ref 2 tables

[gazzy3k]

i know that data should not appear in 2 tables.
but on this ocassion i really need this to work

i have 2 tables table 1 & table 2, table 1 generates the ref code in the field "Ref" 40001 & so on (autonumber). i need the exact same number to be duplicated in field "accref" in table 2.

this is a real puzzle, but it has got to work.

many thanks

 

[Mile-O]

on this ocassion i really need this to work

What's the occasion?

 

[gazzy3k]

my boss is a prat

 

[Mile-O]

What's your current table design?

 

[Pat Hartman]

When you design a relational database, one of the things you do is break the data down into separate tables to eliminate redundancy. Well, the business solutions require that the data be brought back together for ease of use by humans. The way to accomplish that is by creating queries that join separate tables into a single recordset that can be used as the recordsource for a form or report. The way that tables are joined is on key data. An example is a CustomerID. In order to identify the customer who placed an order, the Order table needs to include the CustomerID field otherwise there would be no way to find the customer's name and billing address. CustomerID in the customer table is a primary key because it uniquely identifies a row in the table. CustomerID in the Orders table is a foreign key (OrderID is the primary key). A foreign key is used to hold the value of a primary key from some other table. In a query, the join is between the primary key of the customer table and the related foreign key in the order table.

That said, we don't understand your question.