I have 7 different databases with the same exact fields from different facilities. What is the best way to create a masterdatabase of all of them? Right now...

I have question titled "Adding a database to another" on Nov. 10 I think I may have the lost the person helping me. Is there anyone that can help me?

I apparently lost the person helping me so I will start over here in hopes of getting some help from someone that is more familiar. Once I do it once, I learn...

How do I set the relationships to do the following: Each car belongs to a train Each train belongs to a trainset There are multiple trains in a trainset. I...

I'm looking at getting into web design and don't want to do general courses that I'll never use again! Specific programs/software suggestions would be...

Is there an easy way to set a validation rule for a table field that is based on the value that happens to exist in another field in that same table? What I...

I need to set up a database that will have what seems to be an unending trail. I have a horse table that represents all horses. I also have a progeny table...

I am an administrator over military courses. I'm trying to slim down an overly redundant database. I would like to make it as dynamic as possible. I have...

I am running into a strange problem with Access 2007 table relationships. Earlier, I set up a relationship between our Customer table and a state table...

I'm relatively new to access, so bear with me as I try to explain my issue. I have 2 tables of interest. One table, I'm using as a lookup table and I have...

We are building an Access application which is going to interface with a purchased accounting system. This purchased system will be the source for our...

I'm trying to figure out the following in order to get around the 255 field limitation per table: Table:Details Table:Apps When a record is created in...

Hello All, quick question that may lead to other questions. Can you have more than one many-to-many relationships in one database? If so, is there any...

hi, I have an primary key autonumber field that goes from 1, 2, 3... - 115+ records. I have manually deleted alot of rows till currently left about 45...

I'm very new to Access so this is a very basic question. As my first project I'm setting up a database on politicians in my state. Some will have 2...

This is my first project in Access so this is a very basic question. I'm setting up a database on politicians in my state. Some will have 2 addresses..1 in our...

I'm not sure where to put a couple fields in my database. The database is for info on our company items. I have 3 tables tblItems itemID itemPartNumber...

I'm working on a db of our companys Items. So far I have; tbl Items - ItemID (pk), Item Name, Item Sales Price, etc tblVendor - VendorID (pk), Vend Name,...

I'm trying to setup a database of our company items. Some items have more than one vendor. I'm not sure how to link more than one vendor to an item I...