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...

First, the overall objective. A few others and I work in a dispatch office in a homeless shelter. (I will just be upfront about it.) We are responsible...

Guys I have researched the use of input masks for a problem I'm having (for which I've posted separately), but I am interested in learning why some experts...

I am new with access and need to create a database create and print reports weekly, monthly, yearly and given timeframe, by employee, by task,etc there are...

I am very inexperienced at database design and am saving huge problems. I am trying to construct a Db in Access 2000. The data is based on information from ...

Is there a way to make one field only editable based on the answer (like a Yes/No checkbox) or entry of another field? For example if you have a Yes/No...

If i need a dropdown field (e.g. A, B or C) - is it best to design it in the table or the form?

Hello, I am attempting to create a database that will track student daily student attendance at 11 different after school sites. My database needs to...

Greetings; I have a database that I need to create that has many single checkboxes. This is a medical assessment and has many different sections to rate. ...

Is it possible using the input mask to format all data displayed in a field to Title Case? I've seen that you can use: All characters that...

I have 3 production tables, A, B, C. Each has a PK, to act as parent fields. ( I have 3 production tables b/c each table stores diff types of info for the...

Anyone know a good place on the web to find drop down lists I can use for my lookup fields? Ethnity States Countries, etc Thank you !

Database splitting question: I have a db that contains data tables (fixed information), dynamic tables (info that changes based on users input), queries,...

Access 2003: I have a database containing contact information and other attributes for members of an organization. Some of those members work for...

Hello, Is there a way to print all field names by tables within a database? I have about 25 tables in the database and wondering if there is a way to dump...

Hi, I need to create a list of all the data elements used in my project. The list needs to include the descriptions that I typed into the...

How do you guys go about with your table design... how do you make sure that it's right before proceding with the implementation/coding? Any pointers for a...

Hi, I have a database full of names (for geneology) where I have Last, First, Middle and Title. My table has an auto-number for primary key. From reading...

I am using Access 2003. Is there a way to add a calculated field to a Db Table. I know I can do create a calculated field in a form or a report - but can...

Hi! I'm doing an electronic file indexing program..... tblUSERS connected to tblCABINETS connected to tblDRAWERS connected to tblFILEFOLDERS connected...