I've tried to get to grips with MS Access many times in the past but usually end up totally defeated by trying to understand how relationships work. I have a go, I read the books but nothing seems to work as it should. Now I'm trying to put together an Access database to handle items sold on eBay. I've set up four tables focussing on different parts of the sale (insertion, bid details, despatch, etc.) and I need to have two fields (item and Auction ID) from the first table appear across all four tables, linking the information therein. I created fields in all the tables for these two important items and tried linking them to the first table. In my naivity I thought that if I entered, say, an Auction ID into the first table it would them automatically appear in the other three tables when I opened them. Not the case - as I discovered. What stupid thing am I doing wrong? Am I expecting too much? Have I missed something blindingly obvious? Can anyone prevent Access from beating me to a bloody pulp once again? I'm desperate. I know Access is up to this job but if some kind soul can point me in the right direction I'd be enternally grateful.