I'm working through access 2000, which may make some of you say lol, good luck buddy.
I have a pre-made database that I am working with (probably created way back when stupid was invented). I was assigned to update and put everything on to one, easy to use database. I have multiple tables, each have information I am trying to display on one sheet. I've played with relationships, query's and the like, but I can't seem to get these tables to talk to one another. Each table has been assigned a unique number, which I had to do manually, but different information for similar fields. Not all of them have the same fields, e.g. the main table has 37 fields, the other 10 tables have 5-20 that are related to the main. I would like to join these tables. Any suggestions?
Sorry for posting a trivial question here, $265 is a bit much to pay for it and I couldn't find this information elsewhere. Any help is much appreciated!!