I have been working on a database for an online store that carries a wide variety of product types. I was pointed to sub-classing to resolve the issue of two...

I am in charge of some stores in my school and it is my responsibility to make sure that all items are accountable at all times. Before now, we have used a...

I am trying to create a training data base. My tables include one for employees, one for departments, one for training subject. I need to be able to tell...

I need to generate a lab booking scheme that will enable students and staff to book bench space for their work in a variety of laboratories. Doe anyone have...

This appeared to be the best place for this question as it has to do with wanting to represent my table layouts. I am an access 97 guy, just upgraded to 2003...

I have a system that allows reporting from imported data. I keep a track of what has been imported via a table called tblImportLog. The data itself goes into...

I am looking to combine multiple tables into one table that eliminates duplicates.

I am creating a database which will be used as a backend to an internal website. One of the table will hold data that our customers will fill in. This is more...

Is there a way to determine a table relationship, gather information about the relationship in order to recreate it later. I'm appending data to some tables,...

I have a database to track all employee applicants. There are three tables. tbl #1 "Employee Applicants" : fields: (1) ApplicantID - Autonumber (2) Name -...

I'm trying to understand basic design tradeoffs when using combo boxes. Can anyone please tell me the pros/cons of: 1) defining a combo box in a table as a...

Hello, I posted this question earlier but it is not very well thought out. I am trying to figure out a normalization problem with some table in...

Hello, I have a Case File management db. There can be multiple clients in each case file. Each case file has a primary contact. Each client also can...

I am looking for advice on table and form design as they relate to database performance. I have a Main table with 48 fields. To organize my data better and...

Is it possible to create a Double outter join in Access? If so, what would be the easiest way to do so and what version of Access would i have to...

I'm dealing with a problem and need the easiest solution as possible. I have several tables which have one field in common, let's call it ProductCode, which is...

I have upgraded to SP3, when I did my DateAdd function does not Work. It worked prior to the upgrade. Any body else seen this problem?

Hi, I've got 2 tables - which are basically the same (same fields). Both have one (also the same name) key. One of these tables is linked with other tables via...

I think that it may be repainting because of the way it is doing the query: I think it may be possible that the records are being returned one at a time (or a...

Hi all, I have 2 tables to merge in one table (with the same fields). So i append the data from the second table to the first one. And i do all the work...