Hi, (first post be gentle, very new at Access)
I have 2 tables. tblBus and tblGoods. tblBus has 3 fields (BusID, Date, Destination). BusID is primary key and autonumber. We ship goods on buses. Everytime we ship on a bus, I add the bus in this table.
tblGoods has 4 fields (GoodsID, BusID, Date, Destination). GoodsID is primary key and autonumber. When I print my packing slip, the report writes on which bus the goods left. I don't know how exactly I did it, but it works. If the goods left on bus 5, the number 5 is written in the field BusID in tblGoods.
I would like now to have a query or something similar, that would get the infos from tblBus (Date,Destination) and write them in tblGoods (Date, Destination).
Thanks in advance
Marc