Table

subrata.bauri

I have 2 tables- Table1 and Table2

Table1 has 2 fields Barcode1 and Item Description1. Both fields are populated with values.

Table2 has 2 fields Barcode2 and Item Description2. Here Barcode2 field is populated with values only.


I want to do that If Barcode1=Barcode2 then Description2=Description1.


How can I do that?
Plz reply.

garak

1.) Will you fill the Table2.Description2 per batch or
2.) automaticly if you add an new entry in Table2 in field Barcode2 :?:

Regards

bbrown

Why do you have 2 tables with the same data?

Alex_Chow

subrata.bauri wrote:

I have 2 tables- Table1 and Table2

Table1 has 2 fields Barcode1 and Item Description1. Both fields are populated with values.

Table2 has 2 fields Barcode2 and Item Description2. Here Barcode2 field is populated with values only.


I want to do that If Barcode1=Barcode2 then Description2=Description1.


How can I do that?
Plz reply.

Just create a flowfield.

themave

bbrown wrote:

Why do you have 2 tables with the same data?

I am with you, why not just add barcode2 to the first table
so you have barcode1, barcode2, description