join tables where 2 fields correspond

[ranibosch]

Good day,

i have the following 2 tables:

i want to joint the expiration date to the item ledger entries table.

so basically where the item no + document number is the same in both tables, then bring in the expiration date into the item ledger entries table.

i hope someone can assist with this!

[tresB]

You can move ahead with this existing model (with synthetic keys - as being shown in your model screen shot; please remember synthetic keys are NOT bad if they are not incorrectly modeled). Or, you could create a composite key to associate the fields.

[niclaz79]

Hi,

That's a very simple join to make.

left join(ITEM LEDGDER ENTRIES)

LOAD

     [Item no],

     [Document no],

     [Expiration Date]

Resident [Ambassador Packing List];

drop table [Ambassador Packing List];