I am sure it is quite simple, but for some reason, I can't find the way to do it.
Let us say I have Table A. In the Table A, I have, amongst many others, a Date field.
I also have Table B, with two fields in it. One field is a (unique) Date. The other field is just a number. Let us call it [Day Number].
[Table A/Date] and [Table B/Date] are not linked.
I just want [Table A] to look at its own [Date] field, then search for the corresponding [Date] in [Table B] and retrieve the corresponding [Day Number].
Must not be very difficult, but I can't find the way!
