Crazying with Linking Append Queries!!!!

K

kennykee

I got two table. Relationship is one to many. So "many" table will have a
lookup field to link them.

Then, I got another two more tables with exactly same field but different
lookup connecter.

First types tables = lookup(address,name,contact)

Second types tables = lookup(name, city, address)

With append query, i can copy and paste all the records fields except lookup
field.
Without lookup field, the relationship one to many cannot be establish.

How to handle this problem? Can I just change the lookup criteria and will
it affect the linking of the two tables?

*the two tables combined to become an Invoice (form and subform)

Any solutions?

Thanks in advance

Kennykee
 
Top